PowerProtect Data Manager 19.15 Microsoft SQL Server User Guide

The Microsoft application agent supports browsing and restoring backups to a remote server.

Restore operations to a remote server are supported through the Application Direct SQL Server Management Studio (SSMS) plug-in only.

The Microsoft application agent and Application Direct SSMS plug-in must be installed on the Microsoft SQL Server where you will configure the restore operation. Using the SSMS plug-in, you can browse Microsoft SQL Server backups from any server on the DD storage unit and set the target destination to the remote server where you want to restore the data.

Prerequisites

Ensure that your environment meets the following requirements:

• The Microsoft application agent must be installed on the target remote instance.
• Configure the same lockbox on the target remote instance as the lockbox on the instance where you configure the restore operation.

  For example, if the instance where you are running the restore has a lockbox with DataDomain1 and StorageUnit1, you must create the same lockbox with DataDomain1 and StorageUnit1 on the target remote instance.

• The SQL Server Agent must be running on the target remote instance.

  If the remote instance is on the same domain as the server where you are configuring the restore operation, the Microsoft application agent starts the SQL Server Agent automatically during the restore operation. If the remote server is on a different domain, then you must launch the SQL Server Agent on the target server manually.

• You should be able to connect with the remote instance using the Connect to Server option in the SQL Server Management Studio.

  If you cannot connect to the remote instance, the restore will fail.