PowerProtect Data Manager 19.15 Microsoft SQL Server User Guide

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

ddbmsqlsv -c <client_name> -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 <client_name>

Specifies the Microsoft SQL Server hostname that contains the Microsoft SQL Server instance that you want to back up.

-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 whether the backup destination is a DD server.

-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.

<backup_path>

Specifies the backup path.

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:
  • To back up specific databases, type [MSSQL:]<database> [[MSSQL:]<database> [...]]

  For example: "MSSQL:database1" "MSSQL:database2"

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

  For example: "MSSQL$SqlInst1:database1" "MSSQL$SqlInst1:database2"