How to restore a backup from a backup device (Enterprise Manager)

To restore a backup from a backup device

1. Expand a server group; then expand a server.
2. Expand Databases, right-click the database, point to All Tasks, and then click Restore Database....
3. In Restore as database, enter or select the name of the database to restore if different from the default displayed. To restore the database with a new name, enter the new name of the database.
4. On the General tab, select From device.
5. Click Select devices....
6. Click Add... to specify each backup device containing the backup from which you need to restore.

   In the Choose Restore Destination dialog box, specify either the name of the file or the backup device containing the backup.

7. In the Restore Database dialog box, click View Contents.... Select the backup set to restore.

   ---

   Note This option scans the backup set for the backup content information and can be time consuming, especially when using tape devices. If you already know the backup set to restore, enter the backup set number in Backup number instead.

   ---

8. Under Restore backup set, select:
   • Database - complete to restore a database backup.
   • Database - differential to restore a differential database backup.
   • Transaction log to apply a transaction log backup.
   • File or filegroup to restore a file or filegroup backup. Specify the name of the file or filegroup to restore.
9. On the Options tab, select:
   • Leave database operational. No additional transaction logs can be restored if no further transaction log backups are to be applied.
   • Leave database nonoperational, but able to restore additional transaction logs if another transaction log backup is to be applied.

Note Specifying a new name for the database automatically determines the new names for the database files restored from the database backup.

See Also