Staging a full SQL Server database recovery
This topic describes how to stage a full database recovery. Alternatively, you can restore without staging a full recovery.
To stage a full database recovery
- Browse for a backup image that contains the point in time to which you want to recover.
- 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.
When you view the properties of the transaction log, a Recovery Set tab displays.
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.