To perform backups of SQL Server using a multi-NIC connection, you need to specify the public name of the virtual SQL Server host. You also need to create and edit a batch file for backups so that it includes the private virtual SQL Server name.
To perform backups in a cluster with a multi-NIC connection
On either SQLHOST1 or SQLHOST2, open the NetBackup for SQL Server interface.
In the Host box, specify the public name of the virtual SQL Server host (VIRTSQL).
A batch file similar to the following is created:
OPERATION BACKUP DATABASE "ACCOUNTING" SQLHOST "VIRTSQL" NBSERVER "THOR" BROWSECLIENT "VIRTSQL" MAXTRANSFERSIZE 0 BLOCKSIZE 7 ENDOPER TRUE
Change the line value associated with the BROWSECLIENT from the public virtual SQL Server name to the private name.
OPERATION BACK UPDATABASE "ACCOUNTING" SQLHOST "VIRTSQL" NBSERVER "THOR" BROWSECLIENT "VIRTSQL-NB" MAXTRANSFERSIZE 0 BLOCKSIZE 7 ENDOPER TRUE
Place the modified batch file on both nodes in the cluster so that it is available for scheduled backups. Backups are done regardless of which node is active when a backup is initiated.
More Information