PowerProtect Data Manager 19.15 Microsoft SQL Server User Guide

Run the following command to restore database transaction logs in a stand-alone environment with VM Direct:

ddbmsqlrc.exe -a VM_DIRECT=TRUE -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>" -c <client_or_hostname> [-a "SKIP_CLIENT_RESOLUTION=TRUE"] -C <database_files> -t <last_backup_time_stamp> -S normal -a "RESTORE_START_TIME= <start_date_and_time>"  <restore_path>

where:

-A VM_DIRECT=TRUE

Specifies to use the VM Direct workflow for the recover operation.

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

-c <client_or_hostname>

Specifies the client name that was used for the backup.

-a "SKIP_CLIENT_RESOLUTION=TRUE"

(Optional) Specifies to use the client name as it is exactly entered with the -c option and to skip the FQDN lookup to automatically resolve the client name.

-C <database_files>

Specifies the database and log files for the restore operation.

-t "<last_backup_time_stamp>"

Specifies the backup time stamp that you want to restore.

-S normal

Enables you to roll back uncommitted transactions and use the database to restore the most recent or additional transaction logs.

-a "RESTORE_START_TIME=<start_date_and_time>"

Restores all the backups that were performed at or after a specified backup time (start date and time) and up to the backup time of the selected save set, that is, -t <Last_Backup_Time_Stamp>.

Specify the start date and time in the <mm>/<dd>/<yyyy> <hr>:<mins>:<secs> {AM | PM} format.

The start date and time must not be after the backup time of the selected save set, that is, -t <Last_Backup_Time_Stamp>.

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