Restoring a SQL Server database backup
This topic describes how to restore a database from a full database or differential database backup.
To restore a database backup
- Browse for the backup images you want to restore.
- In the Restore Microsoft SQL Server Objects dialog box, expand the database instance.
- Expand the database.
Select the database image that you want to restore, as follows:
To restore a full backup, select the image of the database backup.
To restore a full backup and a differential database backup, click the "+" and select a differential backup.
The full backup is automatically selected when you select a differential.
- Select the restore options.
To place the database in recovery mode so that it is immediately usable following the restore, select Recovered from the Recovery list. However, be aware that after the database is placed in recovered mode, you cannot update it with additional differential or transaction log backups.
- Click Restore.
- To view the progress of the restore, select File > View status.