PowerProtect Data Manager 19.12 Microsoft SQL Server User Guide

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"