PowerProtect Data Manager 19.9 Microsoft Application Agent SQL Server User Guide

Run the ddbmsqlsv command with the following syntax to back up a stand-alone SQL Server:

ddbmsqlsv -c <cluster_name> -A <virtual_server> -l {full | incr | diff} -a "NSR_DFA_SI_DD_HOST=<server_name>" -a "NSR_DFA_SI_DEVICE_PATH=<storage_unit_name_and_path>" -a "NSR_DFA_SI_DD_USER=<DD_Boost_user>" [<optional_parameters>] "<backup_path>"

Run the ddbmsqlsv command with the following syntax to back up a clusterless Always On availability group (AAG):

ddbmsqlsv -a "SKIP_CLIENT_RESOLUTION=TRUE" -c <AAG_name>_<AAG_GUID> -l {full | incr | diff} -a "NSR_DFA_SI_DD_HOST=<server_name>" -a "NSR_DFA_SI_DEVICE_PATH=<storage_unit_name_and_path>" -a "NSR_DFA_SI_DD_USER=<DD_Boost_user>" [<optional_parameters>] "<backup_path>"

where:

-c <cluster_name>

Specifies the Windows cluster name that you want to back up.

-c <AAG_name>_<AAG_GUID>

Specifies the clusterless AAG that you want to back up, for example, -c AAG1_ef770eaf-ebe3-f5be-bdff-3a7243ff1236.

-A <virtual_server>

Specifies the fully qualified domain name (FQDN) of the SQL virtual server.

NOTE The -A option does not apply to clusterless AAG backups.

-l {full | incr | diff}

Specifies the type of the backup to perform such as full (full), transaction log (incr), or differential (diff). The default value is full.

-a "NSR_DFA_SI_DD_HOST=<server_name>"

Specifies the name of the DD server that contains the storage unit where you want to back up the databases.

-a "NSR_DFA_SI_DEVICE_PATH=<storage_unit_name_and_path>"

Specifies the name and the path of the storage unit where you want to direct the backup.

-a "NSR_DFA_SI_DD_USER=<DD_Boost_user>"

Specifies the username of the DD Boost user.

You must register the hostname and the DD Boost username in the lockbox to enable Microsoft application agent to retrieve the password for the registered user.

-a "SKIP_CLIENT_RESOLUTION=TRUE"

Specifies to skip the client resolution for <AAG_name>_<AAG_GUID>, as specified with the -c option. Skipping the client resolution is required for a clusterless AAG backup.

"<backup_path>"

Specifies the path to the objects that you want to back up.

Type the backup path in one of the following formats:

• For a default instance, type the path in one of the following formats:
  • To back up the entire instance, type MSSQL#<aag_name>:
  • To back up specific databases, type [MSSQL#<aag_name>:]<database> [[MSSQL#<aag_name>:]<database> [...]]

  For example: For example: "MSSQL#aag1:database1" "MSSQL#aag1:database2"

• For a named instance, type the path in one of the following formats:
  • To back up the entire instance, type MSSQL$<Instance_Name>#<aag_name>:
  • To back up specific databases, type MSSQL$<Instance_Name>#<aag_name>:<database> [...]

  For example: "MSSQL$SqlInst1#sql2012-aag3:database1" "MSSQL$SqlInst1#sql2012-aag3:database2"