C.2 Restoring the Backed-Up MS SQL 2005/2008 SP2 Enterprise Database

  1. Launch SQL Management Studio and connect to the server.

  2. Make sure that you do not already have a database with the same name as the database you want to restore.

  3. Right-click the Databases node in the tree on the left.

  4. Select Restore Database.

  5. Specify the new name for the database in the To Database field.

  6. Select From Device.

  7. Click the button.

  8. Click Add and select the file that contains the backup you want to restore.

  9. Click OK.

  10. Select the check box next to the database backup set you want to restore. Only one set should be selected.

  11. Click Options in the list on the left.

  12. Make sure that the location where the database files will be created is correct. Change the location if necessary.

  13. Click OK.