Restoring a 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

  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.

More Information

Staging a full database recovery

Browsing for backup images

500 Internal Server Error

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator at webmaster@systemmanager.forsenergy.ru to inform them of the time this error occurred, and the actions you performed just before this error.

More information about this error may be available in the server error log.

Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request.