Restoring a SQL Server transaction log image without staging a full recovery
This topic describes how to restore a transaction log image without staging a full recovery.
To restore a transaction log without staging a full recovery
- Browse for the backup images you want to restore.
- In the Restore Microsoft SQL Server Objects dialog box, expand the database instance.
- Select the transaction log image that you want to restore.
If a set of images exists that include the transaction log image and that are sufficient for staging a full database recovery, Stage full recovery is enabled. The properties of the transaction log include a Recovery Set tab.
- Select Restore only the transaction log that you selected.
- Click Restore.
To view the progress of the restore, select File > View status.