Configure the primary server host name for the SQL Server agent
In some environments, you may need to override the host name that NetBackup for SQL Server uses for server-directed backup and restores. Specifically, when the primary server knows itself by one host name and the client must connect to a different host name to reach the primary server. For example, when the primary server has more than one IP address or associated host name. In this case some client hosts may not resolve and network route to the host name by which the primary server knows itself.
The SQL Server agent obtains the host name for the primary server from several sources, in the following order:
NBSERVERvalue.For intelligent policies and protection plans, this name is the host name by which the primary server identifies itself. For other operation types, this name is the host name of the primary server that is configured in the batch file. Or, the host name in the operation that the SQL Server backup administrator configured.
SQL Server agent registry setting.
The primary server name () in the NetBackup client properties of the NetBackup MS SQL Client interface. This setting corresponds to the following registry entry:
HKEY_CURRENT_USER\Software\Veritas\NetBackup\NetBackup for Microsoft SQL Server\DEFAULT_SQL_NB_MASTER_SERVERThe first
SERVERentry in the NetBackup registry on the client host.This setting is located in the following registry entry:
HKEY_LOCAL_MACHINE\Software\VERITAS\NetBackup\CurrentVersion\Config\ServerDomain server value.
The host name of the primary server from which the client last requested a host ID certificate. This value is the
"serverName"for the primary server in thecertmapinfo.jsonfile.
Alternatively, you can set USE_REQUESTED_MASTER = FALSE on the client to give the NBSERVER value lower precedence:
SQL Server agent registry value
Primary server value
NBSERVERvalueDomain server value
To change the USE_REQUESTED_MASTER setting to FALSE
- Add the following statement to a text file (for example,
new_config.txt).USE_REQUESTED_MASTER = FALSE - On the primary or the media server, enter the following command:
# bpsetconfig -h ClientA new_config.txtNetBackup sets the configuration change on client host
ClientA.