Restoring database backup files

After extracting the backup ZIP files from the source server, you need to restore the database backup files.

To restore the database backup files

  1. Open Microsoft SQL Server Management Studio.
  2. In the Connect to Server window, select <Browse for more…> at the Server name field.
  3. In the Browse for Servers window, expand the Database Engine option, select the new SOURCEDB database instance you created (this is the second SQL Server instance), and click OK.

    Note: Take note of the names for both SQL Server instances because you will enter the names when running the Parallel Migration Wizard.

  4. In the Connect to Server window, enter the following fields:
    1. Select SQL Server Authentication at the Authentication field.
    2. Enter sa at the Login field.
    3. Enter the password you created for the new SQL Server database instance.
    4. Select the Trust server certificate check box if it appears (the check box appears depending on the version of Microsoft SQL Server Management Studio you're using).
    5. Click Connect.
  5. In Microsoft SQL Server Management Studio, in the Object Explorer, right-click Databases and select Restore Database.
  6. In the Restore Database window, select the Device: option and click the ellipsis (…) button.
  7. In the Select backup devices window, click Add.
  8. In the Backup File window, select MAS_SYSTEM.bak and click OK.
  9. In the Select backup devices window, click OK.
  10. Click Files from Select a page.
  11. In the Restore database files as section, click the Relocate all files to folder check box.
  12. In the Restore Database window, click OK to start restoring the database file.
  13. At the message that the database has been successfully restored, click OK. The restored database appears in the Object Explorer.
  14. Repeat steps 7–15 to restore each database file from the source server.
  15. In the Object Explorer, disconnect from the database instance and then close SQL Server Management Studio.

After completing the steps above, see Running the Parallel Migration Wizard.