In the Restore window, from the NetBackup History pane, select the backup image containing the objects you wish to restore.
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.
Other applications of NetBackup for SQL Server Using NetBackup to restore SQL Server from Backup Exec images
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.
Select Point in time log restore, and then select a date and time.
For information on other SQL restore options, refer to “Restore options” on page 156.
10 Click Start Restore.
Restoring Backup Exec SQL transaction logs backups up to a named transaction
When restoring SQL Server 2000 transaction logs, you can restore transactions from a transaction log up to and including a named transaction (or mark). After the named transaction is reached, recovery from the transaction log is stopped.
To restore a transaction log up to a named transaction
Log on as Administrator. Open the Backup, Archive, and Restore interface.