Other applications of NetBackup for SQL Server Using NetBackup to restore SQL Server from Backup Exec images
From the Source client for restores list, select the desired client.
The source client is the SQL Server machine name whose backup images you would like to browse.
From the Policy type for restores list, choose MS-SQL-Server.
If you wish to redirect a restore to a different client, select the client to which to redirect the restore from the Destination clients for restores list.
See “Redirecting a restore” on page 169 for additional information on redirecting a Backup Exec restore to a different location.
Click OK. NetBackup browses for SQL Server backup images.
The NetBackup History pane displays SQL Server backup information. The top split windows show individual image information and the bottom split gives file and folder information and also allows the user to select what files are to be restored.
Restoring Backup Exec database backups
If the database you wish to restore is using the simple recovery model, there are no transaction log backups to restore. You only need to restore the most recent full database backup and if you were running differential database backups, restore the most recent differential database backup.
To restore a database backup
1 2 3
Log on as Administrator. Open the Backup, Archive, and Restore interface. Specify the appropriate server, client, and policy type.
See “Specifying the server, client, and policy type” on page 160.
Choose File > Select Files and Folders to Restore > from Backup Exec Backup.
In the Restore window, in the NetBackup History pane, select the backup image containing the objects you wish to restore.