How to restore a differential database backup (Enterprise Manager)

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

To restore a differential 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.
   
   
4. Click Database.
   
   
5. In the First backup to restore list, click the backup set to restore.
   
   
6. In the Restore list, click the differential backup to restore.
   
   
7. Optionally, click the Options tab, and then do one of the following:
   • Click Leave database operational. No additional transaction logs can be restored if no further transaction log backups are to be applied.
     
     
   • Click Leave database nonoperational, but able to restore additional transaction logs if another transaction log backup is to be applied.

See Also

Differential Database Backups

Reducing Recovery Time