Using NetBackup for SQL Server with clustering solutions Using SQL Server in a cluster with a multi-interface network connection
Adding permissions that allow for browsing of backups across the private interface
The administrator can allow all clients or allow single clients to browse and restore backups performed over the multi-nic connection.
To allow all clients to browse for backups and perform restores
A d d t h e e m p t y f i l e N B _ I N S T A L L \ d b \ a l t n a m e s \ N o . R e s t r i c t i o n o n t h e master server.
This option allows any NetBackup client to browse backups made by the SQL Server host machine.
To allow a single client to browse for backups and perform restores
A d d t h e e m p t y f i l e , N B _ I N S T A L L \ d b \ a l t n a m e s \ S Q L H O S T o n t h e m a s t e r server.
This only allows the SQL Server host machine, SQLHOST, to access backups managed by the master server.
The private interface name of the SQL Server host machine must be specified in the Backup, Archive, and Restore interface on the client.
The Client name can be set either during the installation of the NetBackup client, or it can be changed in the NetBackup Client Properties dialog box in the Backup, Archive, and Restore interface.
To specify the private name of the client
1 2 3 4
Open the Backup, Archive, and Restore interface. Choose File > NetBackup Client Properties. Click on the General tab. In the Client name box, specify the private name of the client.
For example, the client name used for the SQLHOST1 machine would be SQLHOST1-NB and the client name used for the SQLHOST2 machine would be SQLHOST2-NB.
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 in the SQL Server connection properties dialog box. You also need to create and edit a batch file for backups so that it includes the private virtual SQL Server name.