About configuration of SQL Server backups with multiple NICs
Many administrators want to reserve a separate network interface for their SQL Server host machines that are used for routing backup traffic. This type of environment requires additional configuration for backup policies and the NetBackup client that backs up SQL Server. Special configuration is also required to perform restores.
Note:
In NetBackup 8.1, if you have a SQL Server cluster in a private network additional configuration is required. You must configure the mappings for distributed application restores. You also must review the auto-discovered mappings for the hosts in your environment.
See Configuring mappings for restores of a distributed application, cluster, or virtual machine .
See Reviewing the auto-discovered mappings in Host Management.
The following distinct network resources exist in a multi-NIC environment:
The public name of each SQL Server host (for example,
sqlhost1andsqlhost2)The private interface name that is used to back up each of the SQL Server hosts (for example,
sqlhost1-NBandsqlhost2-NB)
The following additional resources exist for a SQL Server cluster in a multi-NIC environment:
The public virtual name of the SQL Server (for example,
virtsql)The private virtual name of the SQL Server (for example,
virtsql-NB)
The following requirements exist to use NetBackup for SQL Server in a multi-NIC environment:
Install the NetBackup client on the SQL Server using the private name of the SQL Server host as the NetBackup client name.
Alternatively, you can configure the NetBackup client name after installation.
See Configuring the NetBackup client with the private interface name.
Configure a backup policy that includes the private interface name of the host or client.
See Configuring backups of SQL Server when you have multiple NICs (SQL Server Intelligent Policies).
See Configuring backups for SQL Server when you have multiple NICs (legacy SQL Server policies).
See Configuring backups of a SQL Server cluster when you have multiple NICs (legacy SQL Server policies).
Note that if you want to protect a SQL Server cluster with a legacy SQL Server policy, you must edit the backup batch file. The BROWSECLIENT parameter must indicate the private name of SQL Server host or virtual SQL Server.
For restores in a multi-NIC environment, refer to the following topic:
See Performing restores of SQL Server when you have multiple NICs.
If you want to perform a restore from a SQL Server cluster, you must edit the restore batch file. In the batch file, you must change the BROWSECLIENT parameter to indicate the private name of virtual SQL Server.
See Performing restores of a SQL Server cluster when you have multiple NICs.