Other applications of NetBackup for SQL Server Using NetBackup to restore SQL Server from Backup Exec images
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, from the NetBackup History pane, select the backup image containing the last master database backup.
6 7 8
In the All Folders pane, select the master database. Choose Actions > Start Restore of Marked Files.
In the Restore Marked Files dialog box, on the Microsoft SQL Server tab, select Automate master database restore.
When this option is selected, only the master database can be restored; if this option is selected for any other database, those jobs will fail. When you start the restore operation, all existing users are logged off, and SQL Server is put into single-user mode.
If NetBackup does not have access to the SQL registry keys HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server and HKEY_LOCAL_MACHINE\Software\Microsoft\MSSQLServer, then a restore to the default directory may not work, and the option Automate master database restore will not work. To ensure that NetBackup has access rights, verify that the account that NetBackup uses has administrator rights to the computer that is running SQL.
Select a consistency check to be run after the restore.
10 Click Start Restore. After the restore, SQL is restarted in multi-user mode.
Redirecting a restore
You can redirect the following:
A database backup to a different server, database, or instance.
Differential and log backups to wherever the associated database is restored.
One or more filegroups in a backup to a different server or instance. Filegroups can be redirected to a different server, but the database file paths cannot be changed. For example, if the filegroup was backed up from G:\SQLDATA, then it must be restored to G:\SQLDATA, even if it is redirected to another server. Filegroups must be restored to the same drive letter and path that they were backed up from.