Configure backups for SQL Server when you have multiple NICs (batch file-based policies)
This topic describes how to configure a batch file-based policy using batch files to protect SQL Server with a multi-NIC. 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.
To configure backups for SQL Server when you have multiple NICs (batch file-based 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.
- On the left, select Protection > Policies.
Create a new policy or open an existing policy.
- On the Clients tab, add a new client.
For the Client name, provide the private interface name. For example, the public name is
sqlhost1. The private interface that is used to back upsqlhost1issqlhost1-NB. - Create a batch file that includes the private interface name of the virtual SQL Server. Then add this batch file to the backup selections list.
Add other policy information as follows:
Add schedules.