9. Upload the Central Office Database

The next step is to upload the Central Office database to the new computer.

  1. Access Windows with an administrator account on the new computer.

  1. Select Start > All Programs > Microsoft SQL Server 2008 R2 > SQL Server Management Studio.

The Microsoft SQL Server Management Studio displays.

  1. Select Connect > Database Engine.

The Connect to Server window displays.

  1. Complete the following:

  1. In the Authentication field, select "SQL Server Authentication".

  2. In the Login and Password fields, type the credentials for the SQL Server system administrator account.

  1. Click Connect.
  2. Double-click Databases.

  1. Right-click on MillenniumCO and select Tasks > Restore > Database.

The Restore Database - MillenniumCO window displays.

  1. In the Source for restore section, select From device and click  ... .

The Specify Backup window displays.

  1. Click Add.

The Locate Backup File window displays.

  1. Browse to the location where you saved the backup of the database, select the backup, and click OK twice.
  2. In the Select the backup sets to restore section, select Restore next to the backup of the database.

  1. Click OK.

A notification displays once SQL Server uploads the database.

  1. Click OK.
  2. Click here to proceed with the next step of the setup.

 

related links

10. Configure Millennium