Search <book_title>...

NetBackup™ for Microsoft SQL Server Administrator's Guide

Last Published: 2024-03-27

Product(s): NetBackup & Alta Data Protection (10.4)

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 Default Microsoft SQL Server Administrator 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

host-properties API example

https://{{host}}/netbackup/config/hosts/{{host-uuid}}/host-properties

            "clientMssql": {
                "trustServerCertificate": true,
                "preferredODBCDriver": [
                    "OLDEST"
                ],
                "configList": [
                    "host16vm5\\SQL2K22,1633",
                    "host16vm6\\SQL2K22,1634"
                ],
                "encrypt": true
            }

host-properties patch API example

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"
                ]
            }
        }
    }
}