To restore from a Backup Exec image a SQL transaction log up to a named transaction

1. Log on as Administrator.

2. Open the Backup, Archive, and Restore interface.

3. Specify the appropriate server, client, and policy type.

4. Select File > Select Files and Folders to Restore > from Backup Exec Backup.

5. In the Restore window, from the NetBackup History pane, select the backup image that contains the objects you want to restore. In the All Folders pane, select the most recent full database backup. Select also the most recent differential database backup, if any. And select all the log backups you want to restore.

6. Select Actions > Start Restore of Marked Files.

7. In the Restore Marked Files dialog box, from the Recovery completion state group, select Leave database operational. No additional transaction logs can be restored.

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

   The names are case sensitive. Make sure that you enter the correct uppercase and lowercase characters.

   Select from one of the following options:

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

   • To specify a particular named transaction in the log, select Found after and 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.

9. Click Start Restore.