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 level full backup

Run the following command to restore databases with VM Direct:

msagentrc.exe  -A VM_DIRECT=TRUE -A "DM_PORT=<PowerProtect_appliance_port_number>" -A "NSR_RESTORE_TYPE=regular" -c <client_or_hostname> -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>" -A "NSR_DFA_SI_DD_LOCKBOX_PATH=<full_path_to_lockbox>" -A "DM_HOST=<PowerProtect_appliance_hostname>" -A RESTORE_FROM_DD_ONLY=YES -A EXCLUDE_CLIENT_NAME_RESOLUTION=TRUE [<optional_parameters>] -I -
-t <save_time> <restore_path>

where:

-A VM_DIRECT=TRUE
Specifies to use the VM Direct workflow for the recover operation.
-A "DM_PORT=<PowerProtect_appliance_port_number>"
Specifies the port number to communicate with the PowerProtect Data Manager server. The default value is 8443.
-A "NSR_RESTORE_TYPE=regular"
Specifies to perform a database level restore.
-c <client_or_hostname>
Specifies the client name that was used for the backup.
-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_and_path>"
Specifies the name and the path of the storage unit that contains the backup.
-A "NSR_DFA_SI_DD_LOCKBOX_PATH=<full_path_to_lockbox>"
Specifies the folder that contains the lockbox file, which contains encrypted information about the registered hosts and the corresponding usernames in pairs. Each pair is associated with a password that backups use. If you do not specify a value, the path defaults to the installation path, which is typically C:\Program Files\DPSAPPS\common\lockbox.
-A "DM_HOST=<PowerProtect_appliance_hostname>"
Specifies the PowerProtect Data Manager appliance hostname or IP address.
-A RESTORE_FROM_DD_ONLY=YES
Specifies to restore from the DD server.
-A EXCLUDE_CLIENT_NAME_RESOLUTION=TRUE
Specifies to use the client name that is provided as-is without converting it to the fully qualified domain name (FQDN).
-t <save_time>
Specifies the save time of the backup. Specify this parameter along with the restore path for each database in the restore operation. The application pauses for you to input this option line by line. Press Enter to move to the next line. A blank line indicates completion of the list.
<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 a backup of the entire instance, type APPLICATIONS:\SqlServerWriter\<backup_client_name>
    • To restore a backup of specific databases, type APPLICATIONS:\SqlServerWriter\<backup_client_name>\<database_name>\ [...]\

    For example: "APPLICATIONS:\SqlServerWriter\LEDMF158\dbtest3"

  • For a named instance, type the path in one of the following formats:
    • To restore a backup of the entire instance, type APPLICATIONS:\SqlServerWriter\<URL-encoded_SQL_instance_name>
    • To restore a backup of specific databases, type APPLICATIONS:\SqlServerWriter\<URL-encoded_SQL_instance_name>\<database_name>\ [...]\

      The <URL-encoded_SQL_instance_name> is typically <backup_client_name>%5C<SQL_instance_name>

    For example: "APPLICATIONS:\SqlServerWriter\LEDMF158%5Cinst1\dbtest3"

Example VM Direct level full database restore commands

msagentrc.exe  -A VM_DIRECT=TRUE -A DM_MOUNT_TIMEOUT=240 -A DM_HOST=10.125.2.17 -A DM_PORT=8443 -c blrv016b102.vmdirect.com -A NSR_DFA_SI_DD_HOST=10.125.2.34 -A NSR_DFA_SI_DD_USER=SQLite102-blrv016c017-d94a3 -A NSR_DFA_SI_DEVICE_PATH=/SQLite102-blrv016c017-d94a3 -A "NSR_DFA_SI_DD_LOCKBOX_PATH=C:\Program Files\DPSAPPS\common\lockbox" -A RESTORE_FROM_DD_ONLY=YES -A EXCLUDE_CLIENT_NAME_RESOLUTION=TRUE -A NSR_RESTORE_TYPE=regular -I -
    -t 1603971364 APPLICATIONS:\SqlServerWriter\BLRV016B102%5CSQL2017A\sqldatabasename\
msagentrc.exe  -A VM_DIRECT=TRUE -A DM_MOUNT_TIMEOUT=240 -A DM_HOST=12.34.222.184 -A DM_PORT=8443 -c win-appvm-000.appsvm.com -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" -A RESTORE_FROM_DD_ONLY=YES -A NSR_RESTORE_TYPE=regular -I -
    -t 1543513971 APPLICATIONS:\SqlServerWriter\WIN-APPVM-191\ReportServerTempDB\
    -t 1543513971 APPLICATIONS:\SqlServerWriter\WIN-APPVM-191\master\
    -t 1543513971 APPLICATIONS:\SqlServerWriter\WIN-APPVM-191\model\
    -t 1543513971 APPLICATIONS:\SqlServerWriter\WIN-APPVM-191\msdb\
    -t 1543513971 -A ADDITIONAL_RESTORES=yes APPLICATIONS:\SqlServerWriter\WIN-APPVM-191\ReportServer\
    -t 1543513971 -A ADDITIONAL_RESTORES=yes APPLICATIONS:\SqlServerWriter\WIN-APPVM-191\data1\
    -t 1543513971 -A ADDITIONAL_RESTORES=yes APPLICATIONS:\SqlServerWriter\WIN-APPVM-191\data10\
    -t 1543513971 -A ADDITIONAL_RESTORES=yes APPLICATIONS:\SqlServerWriter\WIN-APPVM-191\data11\

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