PowerProtect Data Manager 19.15 Microsoft SQL Server User Guide

When the server nodes contain only default instances, or when the Microsoft SQL Server instance names are all the same in the availability group, type the backup command in the following syntax:

ddbmsqlsv.exe -c SQL2012clus3.brsvlab.local -S 4 -l full -y +30d -a "NSR_DFA_SI_DD_HOST=ddve-01" -a "NSR_DFA_SI_DD_USER=sqlboost" -a "NSR_DFA_SI_PATH=/sqlboost" -a "NSR_DFA_SI_DD_LOCKBOX_PATH=C:\Program Files\DPSAPPS\common\lockbox" -a "NSR_SKIP_NON_BACKUPABLE_STATE_DB=TRUE" "MSSQL$SQ12INST4#sql2012-aag3:" 

where:

• -c SQL2012clus3.brsvlab.local specifies the cluster name.
• "MSSQL$SQ12INST4#sql2012-aag3:" is the backup object name, where all the databases of the sql2012-aag3 Always On availability group are backed up. The backup object name is made of the following components:
  • MSSQL is a mandatory term.
  • If you use named instances, $SQ12INST4 is the Microsoft SQL Server instance name.

    If you use a default instance, do not specify $<Microsoft_SQL_Server_instance_name> in the backup object.

  • # indicates a federated backup.
  • sql2012-aag3 is the AlwaysOn Availability Group name.