Restoring from SQL transaction logs up to a named transaction

The following procedure provides details on how to restore transactions from a transaction log up to and including a named transaction (or mark).

See How to restore from SQL transaction logs up to a named transaction.

To restore from SQL transaction logs up to a named transaction

  1. On the navigation bar, click the arrow next to Restore.

  2. Click New Restore Job.

  3. On the Properties pane, under Source, click Selections.

  4. In the restore selections list, select the most recent full database backup set, and the most recent differential database backup set, if any, and all the log backup sets you want to restore.

  5. On the Properties pane, under Settings, click Microsoft SQL.

  6. On Restore Job Properties dialog box, click Leave the database ready to use; additional transaction logs or differential backups cannot be restored.

  7. Select Restore log up to named transaction, and then enter the name of the transaction.

    The names are case-sensitive. Make sure you enter the correct upper- and lower-case characters.

  8. To include the named transaction in the restore, select Include the named transaction.

  9. To specify a particular named transaction in the log, select Found after and then select a date and time.

    If a date and time are not entered, recovery from the transaction log is stopped at the first transaction with the specified name.

  10. Start the restore job or select other restore options from the Properties pane.

More Information

About restoring SQL databases and file groups

Redirecting restores for SQL

Restoring data by setting job properties

Restoring from SQL transaction logs up to a named transaction