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

An environment must meet the following requirements for application-aware virtual machine restore operations:

  • vCenter 6.5 and VMware ESXi 6.5 or later must be installed.
  • VMware tools version 10.1 or later must be installed and running on the SQL host (virtual machine).
  • The UUID attribute must be enabled in the vSphere Client (disk.EnableUUID=TRUE).

    The following VMware Knowledge Base article provides instructions:

    https://kb.vmware.com/s/article/52815

    NOTE After you set disk.EnableUUID to TRUE, ensure that you reboot the virtual machine.
  • The virtual machine must use SCSI disks only and the number of available SCSI slots must match the number of disks at a minimum.

    For example, a virtual machine with 7 disks requires one SCSI controller but a virtual machine with 8 disks requires 2 SCSI controllers.

  • The SQL Server instance must be up and running on the virtual machine.
  • The SQL Server must be a stand-alone instance or part of a clustered or clusterless Always On availability group that is configured with file share witness.
  • The SQL writer service must be running.
  • The full computer name and FQDN for the SQL virtual machine that are added in the application-aware protection policy must be identical and have the DNS resolve.
  • The user account that is configured in the PowerProtect Data Manager protection policy must have access to perform backup and recovery operations.

    To configure the required permissions, perform the following steps on each protected SQL Server instance:

    1. Create a SQL Login with the user account configured in the PowerProtect Data Manager protection policy.
    2. Add the user the sysadmin SQL Server role.
  • The SQL Server to which the data will be restored must be hosted on a virtual machine that is a discovered asset of PowerProtect Data Manager.

    NOTE If you are restoring data to an alternate location to a SQL Server virtual machine that is not protected in PowerProtect Data Manager, you must manually install the Microsoft application agent on the target virtual machine before you can restore the data. The PowerProtect Microsoft Application Agent Installation Guide provides instructions to install the Microsoft application agent for VM Direct. When you configure the restore operation, you must manually register the DD server, PowerProtect Data Manager appliance, and lockbox details.

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