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 to restore a database with a transaction log backup

Use the ddbmsqlrc command to restore a transaction log from the command prompt for VM Direct workflow backups. This command may be used if the database full backup was restored in the NORECOVERY state.

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"

Example VM Direct transaction logs database restore commands

ddbmsqlrc.exe  -a NSR_DFA_SI_DD_HOST=mars.jupiter.emc.com -a NSR_DFA_SI_DD_USER=PLC-PROTECTION-USER -a NSR_DFA_SI_DEVICE_PATH=/PLC-PROTECTION-123456 -a "NSR_DFA_SI_DD_LOCKBOX_PATH=C:\Program Files\DPSAPPS\common\lockbox" -c appvm-sql.appvmdc.com -a "SKIP_CLIENT_RESOLUTION=TRUE" -C "'DB1'='C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\DB1.mdf', 'DB1_log'='C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\DB1_log.ldf'" -t "11/12/2018 08:54:53 AM" -S normal -a "RESTORE_START_TIME=11/12/2018 08:26:25 AM" -a VM_DIRECT=TRUE MSSQL:DB1
ddbmsqlrc.exe  -a NSR_DFA_SI_DD_HOST=host.lss.emc.com -a NSR_DFA_SI_DD_USER=PLC-PROTECTION-USER -a NSR_DFA_SI_DEVICE_PATH=/PLC-PROTECTION-154 -a "NSR_DFA_SI_DD_LOCKBOX_PATH=C:\Program Files\DPSAPPS\common\lockbox" -c win-appvm-191.appsvm.com -a "SKIP_CLIENT_RESOLUTION=TRUE" -C "'ReportServer'='C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\ReportServer.mdf', 'ReportServer_log'='C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\ReportServer_log.ldf'" -S normal -a "RESTORE_START_TIME=11/29/2018 09:52:52 AM" -a VM_DIRECT=TRUE MSSQL:ReportServer

  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: <>()\