Performing backups in a cluster with a multi-NIC connection

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

  1. On either SQLHOST1 or SQLHOST2, open the NetBackup for SQL Server interface.

  2. Select File > Set SQL Server connection properties.

  3. In the Host box, specify the public name of the virtual SQL Server host (VIRTSQL).

  4. Click Apply and Close.

  5. Select File > Backup SQL Server objects.

  6. Select the databases to back up.

  7. 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.

  8. From the Backup script options, click Save.

  9. 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
    
  10. 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
    
  11. 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

Backup Microsoft SQL Server Objects dialog box