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
  • Manage your Dell EMC sites, products, and product-level contacts using Company Administration.

PowerProtect Data Manager 19.15 Microsoft SQL Server User Guide

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 Always On availability group is a special type of availability group that spans two separate availability groups.

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