To restore a transaction log without staging a full recovery

1. Browse for the backup images you want to restore.

2. In the Restore Microsoft SQL Server Objects dialog box, expand the database instance.

3. 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. When viewing the properties of the transaction log, a Recovery Set tab appears.

4. Select Restore only the transaction log that you selected.

5. Click Restore.

   To view the progress of the restore, select File > View status.