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.