Using NetBackup for SQL Server Using the NetBackup for MS SQL Client interface
Note: The destination host\instance of a move or restore operation is the one that you log into. The source (or browse) host\instance for move or restore operations is designated using the Backup History Options dialog box, which comes up automatically when you choose File > Restore SQL Server objects.
To redirect a database to another location on a different host
The server which backed up the database you wish to restore must appear in the server list of the destination host.
2 3 4
If the server is not in the list, see “Selecting a server” on page 101. Choose File > Set SQL Server connection properties. From the Host list, select the host you wish to restore to. From the Instance list, select the desired instance.
To choose the default instance, either select <default> or leave the field empty.
5 6 7
Click Apply and then Close. Choose File > Set NetBackup client properties.
In the NetBackup client properties dialog box, from the Current NetBackup Server list, select the NetBackup master server which contains the SQL Server backup images that you want to restore on the destination host.
Click OK. Choose File > Restore SQL Server objects.
10 In the Backup History Options dialog box, in the SQL Host list, select the host which has the database you wish to restore.
Also indicate the Source Client, if applicable. Refer to the following descriptions.
From this list, choose the SQL Server host that you would like to generate a backup history for.
Source Client Specifies the NetBackup client name for the selected client. This is the name used in the policy to identify the client.
If you use a specific network interface for backup, then the network interface name should be entered in the Source Client box. The network interface name is defined in the Host Properties for the server (open the properties for the server and click Universal Settings).