PowerProtect Data Manager 19.15 Microsoft SQL Server User Guide

Configuring Microsoft SQL Server application-aware protection with TSDM

Complete the following steps to configure the Microsoft SQL Server application-aware protection with the transparent snapshot data mover (TSDM).

The PowerProtect Data Manager Virtual Machine User Guide provides more details about each of the following steps.

1. Ensure that the vCenter Server is enabled as an asset source in the PowerProtect Data Manager UI.

2. Add and register the vCenter Server asset source. From the left navigation pane, select Infrastructure > Asset Sources and click Add on the vCenter tab.

   After the successful discovery of the vCenter asset source, the virtual machine assets in the vCenter server are displayed in the Infrastructure > Assets window on the Virtual Machine tab.

3. Ensure that the required application-aware protection policy is created for the Microsoft SQL Server application-aware backups.

   To create the protection policy, follow the procedure under "Add a protection policy" in the PowerProtect Data Manager Virtual Machine User Guide:

   1. On the Add Policy > Type page, select the Virtual Machine type.
   2. On the Add Policy > Purpose page, select Application Aware.
   3. On the Add Policy > Options page, select the Transparent Snapshots protection mechanism.
      NOTE:On the Options page, VADP is the other available protection mechanism option.

   After you finish creating the protection policy, system jobs are created for the virtual machine policy configuration.

   NOTE:For TSDM SQL application-aware backups, with the firewall enabled, you must add a firewall exception for the vflragentd process.