MSSQL_CONFIG_LIST for SQL Server clients
The MSSQL_CONFIG_LIST option provides support for the non-readable secondary instance that is hidden. No configuration on the secondary that provides the port number of the primary to NetBackup, so the NetBackup user must provide it.
Table: MSSQL_CONFIG_LIST information
Usage | Description |
|---|---|
Where to use | On NetBackup SQL Server clients. |
How to use | Use the bpgetconfig and the bpsetconfig commands to view, add, or change the option. For information about these commands, see the NetBackup Commands Reference Guide. To add the port number of the primary, use the following format: MSSQL_CONFIG_LIST = "hostname\instance,port" For example: |
Equivalent NetBackup web UI property | No equivalent exists in host properties. A user with the necessary RBAC permissions can also use the hostProperties API endpoint to configure this setting. See the NetBackup Web UI Microsoft SQL Server Administrator's Guide for details. |
To configure the port settings on multiple nodes
- Set the
host\instance,porton the first node.C:\Veritas\NetBackup\bin\admincmd>bpsetconfig -h host16vm5 bpsetconfig> MSSQL_CONFIG_LIST=host16vm5\SQL2K22,1633 bpsetconfig> MSSQL_CONFIG_LIST=host16vm6\SQL2K22,1634 bpsetconfig> ^Z
- Use bpgetconfig to copy the settings to a file.
F:\Veritas\NetBackup\bin\admincmd>bpgetconfig -M host16vm5 | findstr MSSQL_CONFIG_LIST > settings.out
- Use the file to set the configuration on all the other nodes.
C:\Veritas\NetBackup\bin\admincmd>bpsetconfig -h host16vm6 settings.out
- Use bpgetconfig to validate the setting.
F:\Veritas\NetBackup\bin\admincmd>bpgetconfig -M host16vm6 | findstr MSSQL_CONFIG_LIST MSSQL_CONFIG_LIST = host16vm5\SQL2K22,1633 MSSQL_CONFIG_LIST = host16vm6\SQL2K22,1634