Configure NetBackup for the SQL Server non-readable secondary instances that are hidden
To support the non-readable secondary instances that are hidden, additional configuration is required. No configuration on the secondary provides the port number of the primary to NetBackup, so the NetBackup user must provide it. These settings are configured in the host properties for the client and can only be configured with the hostProperties API endpoint or the bpsetconfig command.
Note:
The RBAC role does not have permissions to edit the host properties. Alternatively, workload administrators can log on locally to the host and use the bpsetconfig command to make the host property changes.
This entry is a multi-string entry. Each entry is in the form that is normally used to connect to the instances with SQL Server utilities: host\instance,port
https://{{host}}/netbackup/config/hosts/{{host-uuid}}/host-properties
"clientMssql": {
"trustServerCertificate": true,
"preferredODBCDriver": [
"OLDEST"
],
"configList": [
"host16vm5\\SQL2K22,1633",
"host16vm6\\SQL2K22,1634"
],
"encrypt": true
}
patch: https://{{host}}/netbackup/config/hosts/{{host-uuid}}/host-properties
{
"data": {
"type": "hostProperties",
"id": "{{host-uuid}}",
"attributes": {
"clientMssql": {
"configList": [
"host16vm5\\SQL2K22,1633",
"host16vm6\\SQL2K22,1634"
]
}
}
}
}