How to restore a database backup (Enterprise Manager)

Note  If you are restoring a database backup that does not have any backup set information listed in the backup history stored in the msdb database, such as a database backup created on another server, see How to restore a backup from a backupdevice.

To restore a database backup

1. Expand a server group, and then expand a server.
   
   
2. Expand Databases, right-click the database, point to All Tasks, and then click Restore Database.
   
   
3. In the Restore as database box, type or select the name of the database to restore, if different from the default. To restore the database with a new name, type the new name of the database.
   
   
4. Click Database.
   
   
5. In the First backup to restore list, click the backup set to restore.
   
   
6. In the Restore list, click the database backup to restore.
   
   
7. Optionally, click the Options tab and do the following:
   • In Restore as, type the new name or location for each database file comprising the database backup.

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

   • Click Leave database operational. No additional transaction logs can be restored if no further transaction log or differential database backups are to be applied.
     
     
   • Click Leave database nonoperational, but able to restore additional transaction logs if another transaction log or differential database backup is to be applied.

See Also

Transaction Log Backups

Database Backups

Differential Database Backups

Identifying the Backup Set to Restore

Rebuilding the master Database

Restoring a Database to a Prior State

Restoring the master Database from a Current Backup

Restoring the model, msdb, and distribution Databases

Reducing Recovery Time