Symantec Backup Exec

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.