Configuring 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.
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.
- Open the NetBackup Administration Console.
- Expand NetBackup Management > Applications > Microsoft SQL Server.
- Click All Instances.
- Find and register the instance that has the private interface name of the SQL Server host (sqlhost1-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 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.