Configure backups of SQL Server when you have multiple NICs (SQL Server Intelligent Policies)
This topic describes how to create a SQL Server Intelligent Policy to protect a SQL Server when you have multiple NICs. The following configuration changes must be made to allow for backups and restores over a private interface:
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 Configure the NetBackup client with the private interface name.
The backup policy must include the private interface name of the SQL Server host.
During instance discovery NetBackup automatically adds an instance with the NetBackup client name. If you installed the NetBackup client using the private interface name, NetBackup uses the private name when it performs backups.
To configure a backup policy for a SQL Server in a cluster with a multi-NIC (SQL Server Intelligent Policies)
- If you installed the NetBackup client on the SQL Server host using the public interface name, follow the procedure to configure the NetBackup client name as the private interface name.
See Configure the NetBackup client with the private interface name.
- Sign in to the primary server as a user that has the RBAC Administrator role or a role that can manage policies.
- Find and register the instance that has the private interface name of the SQL Server host (
sqlhost1-NB). - On the left, select Protection > Policies.
Create a new policy or open an existing policy.
- On the Instances and databases tab, select Protect availability groups or Protect intelligent groups.
- Select Add.
- To add the instances or databases that you want to protect, select or expand the instance that has the private interface name of the SQL Server (
sqlhost1-NB). Add other policy information as follows:
Add schedules.
Add database objects to the backup selections list.
(Optional) Make changes to any tuning parameters.