Restore the .BAK files from the Backup Utility

Restore the saved .BAK files to your new server.

Procedure

  1. Start SQL Server Management Studio. From the Windows Start menu, select All Programs. Within the list of programs, locate Microsoft SQL Server and then locate and click SQL Server Management Studio.
  2. In the Connect to Server window, check the following is correct then click Connect.
    • Server Type: Database Engine.
    • Server name: Server Name/HCNSQL07
    • Authentication
  3. In the Object Explorer screen, right-click Database > Restore.
  4. In the Restore Database window, on the General tab, select Source.
  5. In the Destination for Restore To Database field, type the name of the practice database.
  6. Under Source For Restore, select From Device, then click the Ellipsis icon Ellipsis button.
  7. Click Add, and browse to the location your database (.bak), then click OK.
  8. In Select Backup Sets to Restore, set Restore.
  9. Click Options.
  10. In the Restore Options window, set Overwrite the existing database.
  11. Click OK.

Results

The .BAK files are restored on the new server.