Staging a full SQL Server database recovery

This topic describes how to stage a full database recovery.

To stage a full database recovery

Browse for a backup image that contains the point in time to which you want to recover.
In the Restore Microsoft SQL Server Objects dialog box, expand the database instance.
Click the "+" next to the database that contains the transaction log backup you want to restore.
Select the transaction log image that includes the point in time from which you want to recover.
Select Stage full recovery.
Stage full recovery is enabled if a set of images exists that includes the transaction log image and that are adequate for staging a full database recovery. When you are viewing the properties of the transaction log, a Recovery Set tab appears.
The recovery set can include any combination of backup images that are sufficient for staging the full recovery. These can include full database, filegroup, and differentials.
Click Restore.
To view the progress of the restore, select File > View status.

More Information