Configuring backups for SQL Server when you have multiple NICs (legacy SQL Server policies)
This topic describes how to configure a legacy backup 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 Configuring 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 (legacy backup 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 Configuring the NetBackup client with the private interface name.
- Open the NetBackup Administration Console.
- 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. Add other policy information as follows:
Add schedules.
Create and add batch files to the backup selections list.