PowerProtect Data Manager 19.19 Microsoft SQL Server User Guide

PDF

Protecting Microsoft SQL Server clustered environments

Learn how to configure protection of Microsoft SQL Server clustered environments, including Always On availability groups and Failover Cluster Instances.

About this task

NOTE:

PowerProtect Data Manager does not support a distributed Always On availability group (distributed AAG) Microsoft SQL Server. A distributed AAG is a special type of availability group that spans two separate availability groups.

PowerProtect Data Manager does not support a clusterless Always On Failover Cluster Instance (AAG over FCI) Microsoft SQL Server. An AAG is clusterless when you select NONE for the Cluster type on the Availability Group Options page in the SQL Server Management Studio (SSMS).

PowerProtect Data Manager supports a clustered AAG over FCI Microsoft SQL Server. To configure a clustered AAG, select Windows Server Failover Cluster for the Cluster type on the Availability Group Options page in the SSMS.

On each node in the cluster. Repeat the steps to install the Microsoft application agent, and then add and discover the application host in PowerProtect Data Manager.

CAUTION:Protection of Failover Cluster Instances (FCI) requires that all nodes in the cluster be registered to the PowerProtect Data Manager server. Before registration, the node must be the active node and own all the disks in the cluster. The recommended method is to failover all nodes to the registering node. Repeat this step for all nodes in the cluster and any nodes added to the cluster. Failure to perform this step results in unpredictable results during protection policy.

Steps

  1. Add a storage system.
    The PowerProtect Data Manager Administrator Guide provides information.
  2. Install the Microsoft application agent on each node in the cluster.
  3. Configure the required user privileges on each node in the cluster.
  4. Add or approve the Microsoft application agent on each node in the cluster.
  5. Discover and add the credentials for each Microsoft SQL Server application host.
  6. Create a protection policy to protect the cluster.

    Protection policies for Microsoft SQL Server database protection provides information.

    NOTE:You cannot perform a backup to a secondary DD device. You can only restore from a secondary DD device.

Rate this content

Accurate
Useful
Easy to understand
Was this article helpful?
0/3000 characters
  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: <>()\