PowerProtect Data Manager 19.15 Microsoft SQL Server User Guide

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

• vCenter 6.7 and VMware ESXi 6.7 or later must be installed.
• VMware Tools version 11 or later must be installed and running on the Microsoft SQL Server 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 Microsoft SQL Server instance must be up and running on the virtual machine.
• The Microsoft 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 Microsoft SQL Server 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 Microsoft 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 Microsoft SQL Server role.

• The Microsoft 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 Microsoft 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 server, and lockbox details.