Skip to main content
  • Place orders quickly and easily
  • View orders and track your shipping status
  • Enjoy members-only rewards and discounts
  • Create and access a list of your products

PowerProtect Data Manager 19.9 Microsoft Application Agent SQL Server User Guide

PDF

Syntax for backups of a stand-alone server

Run the ddbmsqlsv command with the following syntax to back up a stand-alone 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 SQL Server hostname that contains the 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"

SQL stand-alone backup command

ddbmsqlsv.exe -c SQLX86.adesc.com -l full -a "NSR_DFA_SI_DD_HOST=10.31.196.90" -a "NSR_DFA_SI_DD_USER=ost" -a "NSR_DFA_SI_DEVICE_PATH=/sqlserver" "MSSQL$INST2008:d2"

  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please select whether the article was helpful or not.
  Comments cannot contain these special characters: <>()\