Hi Friends,
Veritas now provides MSSQL DBAs the ability to protect MSSQL Availability Group secondary replicas that have been configured as non-readable.
Setup and Configuration
Setup and configuration is simple and requires the Veritas NetBackup Windows Client software as well as MSSQL 2012 or greater with Availability Group feature. Veritas software can be downloaded from:
https://www.veritas.com/content/support/en_US/downloads
If using installing using hidden instances, additional configuration is required. There is no configuration on the secondary that gives the port number of the primary, so you must provide it.
The configuration is done in the bp.conf entry: (Computer\HKEY_LOCAL_MACHINE\SOFTWARE\VERITAS\NetBackup\CurrentVersion\Config) MSSQL_CONFIG_LIST which is a multi-string (REG_MULTI_SZ) entry. Each entry is in the form normally used to connect to the instances via SqlServer utilities “host\instance,port” e.g. “myhost\SQL2K12,12345”. This can be set via bpsetconfig.
Example setting the configuration on both nodes:
- Set the host\instance,port on the first node.
F:\Veritas\NetBackup\bin\admincmd>bpsetconfig -h sofia16vm5
bpsetconfig> MSSQL_CONFIG_LIST=sofia16vm5\SQL2K22,1633
bpsetconfig> MSSQL_CONFIG_LIST=sofia16vm6\SQL2K22,1634
bpsetconfig> ^Z
2. Use bpgetconfig to copy the settings to a file.
F:\Veritas\NetBackup\bin\admincmd>bpgetconfig -M sofia16vm5 | findstr MSSQL_CONFIG_LIST > settings.out
3. Use the file to set the config on all the other nodes.
F:\Veritas\NetBackup\bin\admincmd>bpsetconfig -h sofia16vm6 settings.out
4. Validate the setting via bpgetconfig.
F:\Veritas\NetBackup\bin\admincmd>bpgetconfig -M sofia16vm6 | findstr MSSQL_CONFIG_LIST
MSSQL_CONFIG_LIST = sofia16vm5\SQL2K22,1633
MSSQL_CONFIG_LIST = sofia16vm6\SQL2K22,1634
5. The information is also available via the host-properties api in the clientMssql section:
https://{{host}}/netbackup/config/hosts/{{host-uuid}}/host-properties
"clientMssql": {
"trustServerCertificate": true,
"preferredODBCDriver": [
"OLDEST"
],
"configList": [
"sofia16vm5\\SQL2K22,1633",
"sofia16vm6\\SQL2K22,1634"
],
"encrypt": true
},
6. And can be patched via the same api:
patch: https://{{host}}/netbackup/config/hosts/736a913a-88e6-4c89-b714-b58443b43cd2/host-properties
{
"data": {
"type": "hostProperties",
"id": "736a913a-88e6-4c89-b714-b58443b43cd2",
"attributes": {
"clientMssql": {
"configList": [
"sofia16vm5\\SQL2K22,1633",
"sofia16vm6\\SQL2K22,1634"
]
}
}
}
}
Veritas NetBackup is not just your trusted on-site backup suite, it’s also your one stop shop to backup to your cloud resources with simple tools that accomplish difficult tasks. NetBackup enterprise tools makes backing up your data easier and more secure than ever
