In the Restore window, from the NetBackup History pane, select the backup image containing the objects you In the All Folders pane, select the most recent full database backup, and the most recent differential database backup, if any, and all the log backups you want to restore.

164

Other applications of NetBackup for SQL Server Using NetBackup to restore SQL Server from Backup Exec images

6 7

Choose Actions > Start Restore of Marked Files.

In the Restore Marked Files dialog box, from the Recovery completion state group, choose 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 you enter the correct upper- and lower-case characters.

■

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

For information on other SQL restore options, refer to “Restore options” on page 156.