Dell PowerProtect Data Manager Appliance 5.12.0.1 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 Protection Storage server that contains the backup.

When you have a remote (secondary) Protection Storage server that has replicated databases to restore, type the name of the secondary server. A Protection Storage user on the secondary Protection Storage 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"