Configuring 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)
- Open the NetBackup Administration Console.
- Expand NetBackup Management > Applications > Microsoft SQL Server.
- Click All Instances.
- Manually add a new instance and register it. For the Host, provide the private interface name of the virtual SQL Server (
virtsql-NB). - Create a new policy or open an existing policy.
- On the Instances and Databases tab, select Protect instances.
- Click New.
- 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). Add other policy information as follows:
Add schedules.
Add database objects to the backup selections list.
(Optional) Make changes to any tuning parameters.