Configure backups of a SQL Server cluster 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. During instance discovery NetBackup automatically adds an instance with the NetBackup client name. For a virtual SQL Server in a multi-NIC environment, you must add and register the instance with the private interface name of the virtual SQL Server. This name is the instance name that you add to the backup policy.
To configure a backup policy for a SQL Server cluster with a multi-NIC (SQL Server Intelligent Policies)
- Sign in to the primary server as a user that has the RBAC Administrator role or a role that can manage policies.
- Manually add a new instance and register it. For the Host, provide the private interface name of the virtual SQL Server (
virtsql-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 virtual SQL Server (
virtsql-NB). Or, select the intelligent groups that you want to protect.See Add instances to a policy.
Add other policy information as follows:
Add schedules.
Add database objects to the backup selections list. Filegroups and files cannot be selected for policies that use intelligent groups.
(Optional) Make changes to any tuning parameters.