PowerProtect Data Manager 19.9 Microsoft Application Agent SQL Server User Guide

Run the following command to restore databases in an Always On availability group environment:

ddbmsqlrc.exe -c <cluster_name> -A <virtual_server> -S {normal | norecover | standby:<filepath>\undo.ldf} -a "NSR_DFA_SI_DD_HOST=<server_name>" -a "NSR_DFA_SI_DD_USER=<DD_Boost_user>" -a "NSR_DFA_SI_DEVICE_PATH=<storage_unit_name_and_path>" [<optional_parameters>] "<restore_path>"

Run the following command to restore databases in a clusterless Always On availability group (AAG) environment:

ddbmsqlrc.exe -a "SKIP_CLIENT_RESOLUTION=TRUE" -c <AAG_name>_<AAG_GUID> -S {normal | norecover | standby:<filepath>\undo.ldf} -a "NSR_DFA_SI_DD_HOST=<server_name>" -a "NSR_DFA_SI_DD_USER=<DD_Boost_user>" -a "NSR_DFA_SI_DEVICE_PATH=<storage_unit_name_and_path>" [<optional_parameters>] "<restore_path>"

where:

-c <client_name>

Specifies the Windows cluster name for the restore.

To perform a redirected restore, specify a SQL Server host that is not the current host.

-c <AAG_name>_<AAG_GUID>

Specifies the clusterless AAG for the restore, for example, -c AAG1_ef770eaf-ebe3-f5be-bdff-3a7243ff1236.

-A <virtual_server>

Specifies the SQL virtual server FQDN to restore the databases from the SQL clustered instance.

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

-S {normal | norecover | standby:<filepath>\undo.ldf}

Performs one of the following tasks:

• normal: Enables you to roll back uncommitted transactions and use the database to restore the most recent or additional transaction logs.
• norecover: Disables your ability to roll back uncommitted transactions and use the database to restore the most recent or additional transaction logs.
• standby:<filepath>\undo.ldf: Enables you to undo committed transactions, saves the undo actions in a standby file that enables you to reverse the restore effects, and puts the database in the read-only mode.

-a "NSR_DFA_SI_DD_HOST=<server_name>"

Specifies the name of the DD server that contains the backup.

When you have a remote (secondary) DD server that has replicated databases to restore, type the name of the secondary server. A DD user on the secondary DD server must be in the same group as the primary server.

-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 "NSR_DFA_SI_DEVICE_PATH=<storage_unit_name_and_path>"

Specifies the name and the path of the storage unit that contains the backup.

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

"<restore_path>"

Specifies the path to the backup objects that you want to restore.

Type the backup path in one of the following formats:

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

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

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

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