Restoring Backup Exec SQL transaction logs backups up to a point in time

You can restore transactions from a transaction log up to and including a point in time in the transaction log. After the point in time is reached, recovery from the transaction log stops.

To restore SQL transaction logs up to a point in time from Backup Exec images

  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.

  6. 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.

  7. Select Actions > Start Restore of Marked Files.

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

  9. Select Point in time log restore and select a date and time.

  10. Click Start Restore.

More Information

Specifying the server, client, and policy type