C.1 Restoring the Backed-Up MS SQL 2000 Database

  1. Launch Enterprise manager 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 All Tasks > Restore Database from the pop-up menu.

  5. Specify a new name for the database in the Restore As Database field.

  6. Select Restore From Device.

  7. Click Select Devices.

  8. Click Add.

  9. Select the file that contains the backup you want to restore.

  10. Click OK.

  11. Select Restore backup set: Complete.

  12. Click the Options tab and make sure that the location where the database files will be created is correct. Change the location if necessary.

  13. Click OK.