This topic describes how to restore a database from a full database or differential database backup.
To restore a database backup
In the Restore Microsoft SQL Server Objects dialog box, expand the database instance.
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.
To view the progress of the restore, select File > View status.
More Information