Using NetBackup for SQL Server with clustering solutions Using SQL Server in a cluster with a multi-interface network connection
To perform backups
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).
4 5 6 7
Click Apply and Close. Choose File > Backup SQL Server objects. Select the databases to back up. Select the desired backup options.
Note: Do not attempt to perform an immediate backup from the backup dialog box. The generated batch files must be modified before they can be run successfully.
From the Backup script options, choose Save.
Click Backup. A batch file similar to the following will be created:
OPERATION BACKUP DATABASE "ACCOUNTING" SQLHOST "VIRTSQL" NBSERVER "THOR" BROWSECLIENT "VIRTSQL" MAXTRANSFERSIZE 0 BLOCKSIZE 7 ENDOPER TRUE
10 Change the line value associated with BROWSECLIENT from the public virtual SQL Server name to the private name.
OPERATION BACKUP DATABASE "ACCOUNTING" SQLHOST "VIRTSQL" NBSERVER "THOR" BROWSECLIENT "VIRTSQL-NB" MAXTRANSFERSIZE 0 BLOCKSIZE 7 ENDOPER TRUE
11 Place the modified batch file on both nodes in the cluster so that it will be available for scheduled backups, regardless of which node is active when a backup is initiated.