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

Prerequisites for restoring a database to a remote server

Learn how to restore a database to a remote SQL Server instance.

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 SQL Server where you will configure the restore operation. Using the SSMS plug-in, you can browse SQL 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.


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