Using NetBackup for SQL Server with clustering solutions Using SQL Server in a cluster with a multi-interface network connection
Performing restores in a cluster with a multi-NIC connection
To perform restores of SQL Server in a multi-NIC, cluster environment, you need to specify the public name of the virtual SQL Server host in the SQL Server connection properties dialog box and both the virtual SQL Server host name and the private interface name of the virtual SQL Server host in the Browse History Options dialog box. You also need to create a batch file for restores and manually edit it to include the private name of the virtual SQL Server.
To perform restores
On either SQLHOST1 or SQLHOST2, open the NetBackup for SQL Server interface.
Choose File > Set SQL Server connection properties.
In the Host box, specify the public name of the virtual SQL Server host (VIRTSQL).
Click Apply and Close. Choose File > Restore SQL Server objects. In the Backup History Options dialog box, do the following.
In the SQL Host box, specify the public name of the virtual SQL Server (VIRTSQL).
In the Source Client box, specify the private name of the virtual SQL Server (VIRTSQL-NB).
4 5 6
Select the databases to restore.
Note: Do not attempt to perform an immediate restore from the restore dialog box. The generated batch files must be modified before they can be run successfully.
Select the desired restore options. From the Restore script options, choose Save.
11 Click Restore. A batch file similar to the following is generated.
OPERATION RESTORE OBJECTTYPE DATABASE DATABASE "ACCOUNTING" NBIMAGE "SQLHOST1.MSSQL7.VIRTSQL.db.ACCOUNTING.~.7.001of001.20040306111309..C" SQLHOST "VIRTSQL" NBSERVER "THOR"