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.
- Expand the database instance and 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.
- Select the restore options.
- Click Restore.