PowerProtect Data Manager 19.12 Microsoft SQL Server User Guide

Run the following command to restore databases in a stand-alone environment:

ddbmsqlrc.exe -c <client_name> -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 Microsoft SQL Server hostname, to which you want to restore the required databases. A Microsoft SQL Server host contains the backed-up stand-alone or clustered Microsoft SQL Server instances and the corresponding databases.

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

"<restore_path>"

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

Type the restore 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:
  • To restore backups of 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 restore backups of the entire instance, type MSSQL$<Instance_Name>:
  • To restore backups of specific databases, type MSSQL$<Instance_Name>:<database> [...]

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