PowerProtect Data Manager 19.15 Microsoft SQL Server User Guide

Mount VM Direct backups for table-level recovery using the command prompt

Use the msagentrc.exe command with the -A NSR_RESTORE_TYPE=mount parameter to mount backups for table-level recovery.

Type the recover command with the following syntax to mount VM Direct backup images:

msagentrc.exe -A VM_DIRECT=TRUE -c <client_or_hostname> [-A "SKIP_CLIENT_RESOLUTION=TRUE"] -A NSR_RESTORE_TYPE=mount -A "NSR_DFA_SI_DD_HOST=<server_name>" -A "NSR_DFA_SI_DD_USER=<DD_Boost_username>" -A "NSR_DFA_SI_DEVICE_PATH=<storage_unit_name_and_path>" -A "DM_HOST=<PowerProtect_server_hostname>" [-A "DM_USER=<PowerProtect_server_user>"] [-A "DM_PORT=<PowerProtect_server_port_number>"] [-A "DM_MOUNT_TIMEOUT=<number_of_minutes>"] [-A "NSR_DFA_SI_DD_LOCKBOX_PATH=<full_path_to_lockbox>"] -I - 
-t <save_time> <restore_path>

where:

-A VM_DIRECT=TRUE

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

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

-A NSR_RESTORE_TYPE=mount

Specifies a mount 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_username>"

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.

-A "DM_HOST=<PowerProtect_server_hostname>"

Specifies the PowerProtect Data Manager server hostname or IP address.

-A "DM_USER=<PowerProtect_server_user>"

(Optional) Specifies the username to use for the PowerProtect Data Manager connection.

This parameter is mandatory only for credential-based access to the PowerProtect Data Manager server. You are not required to specify this parameter when the Microsoft application agent is approved by PowerProtect Data Manager.

When you add a virtual machine to a Lifecycle group, that virtual machine is approved with a certificate that expires after one day. The PowerProtect Data Manager administrator can approve the target Microsoft application agent on the PowerProtect Data Manager Infrastructure > Agents page.

-A "DM_PORT=<PowerProtect_server_port_number>"

(Optional) Specifies the port number to communicate with the PowerProtect Data Manager server. The default value is 8443.

-A "DM_MOUNT_TIMEOUT=<number_of_minutes>"

(Optional) Specifies the amount of time in minutes until the mount times out. The default value is 4 hours (240 minutes).

-A "NSR_DFA_SI_DD_LOCKBOX_PATH=<full_path_to_lockbox>"

(Optional) 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.

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