Creating a batch file for backups of a SQL Server cluster when you have multiple NICs (legacy SQL Server policies)
This topic describes how to create a batch file for a legacy backup policy to protect a SQL Server cluster with a multi-NIC connection. To create the batch file you need to connect to the SQL Server host using the public name of the virtual SQL Server. The batch file must include the private name of the virtual SQL Server.
To create a batch file for SQL Server cluster backups with a multi-NIC connection
- On any node in the SQL Server cluster, open the NetBackup for SQL Server interface.
- Select 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.
- Select File > Backup SQL Server objects.
- Select the databases to back up.
- Select the 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, click Save.
- Click Backup.
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 that is associated with the
BROWSECLIENTfrom the public name of the virtual SQL Server 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 all nodes in the cluster or in a shared location. This way it is available for scheduled backups.
Backups are done regardless of which node is active when a backup is initiated.