PowerProtect Data Manager 19.15 Microsoft SQL Server User Guide

You can change the assets view to display all assets that are discovered by PowerProtect Data Manager or a hierarchical view with the assets in a tree structure underneath the application host. For example, a hierarchical view might be helpful when you have added multiple SQL databases, so that you can more easily identify which assets belong to which host and instance.

• List view ()—This view uses a table display that enables you to see all unprotected assets within a table, and then select individual unprotected assets that you want to include in the protection policy.

• Hierarchical view ()—This view uses a tree view that shows the hierarchical relationships of the Microsoft SQL Server hosts, their application servers or instances (including Failover Cluster Instances (FCIs)), stand-alone database assets, and any Always On availability groups (AAGs) with their database assets.

  When you expand the hierarchical or tree view, you can see all the assets and AAGs within a host and instance. When you select a host or instance container, all the contained assets and objects are also selected. You can also select individual assets or a group of assets within the host or instance container to include in the protection policy.

  NOTE:

  For FCIs and AAGs, when you select the node of one host, the same selection automatically applies to the other hosts in the cluster.

  The hierarchical view is supported only for an Application Direct protection policy, not an application-aware protection policy.

  The hierarchical view is also available on the following pages in the PowerProtect Data Manager UI:

  • Protection > Protection Policies > Protect Now
  • Protection > Protection Policies > Edit Policy > Assets
  • Infrastructure > Assets
  • Restore > Assets

When you select a host or instance within the hierarchical view, the and icons appear on the container line. If a selected instance is the only instance on a host, the icons appear on the host line above the instance, not on the instance line.

• Dynamic Protection ()—Dynamic protection is enabled by default. When dynamic protection is enabled, a dynamic protection rule is automatically created to ensure that all the selected assets within the selected host or instance container are dynamically protected by the protection policy. PowerProtect Data Manager manages the protection rule. The rule is updated automatically when you edit the policy and make changes to the container selections, or when assets are moved into or out of a selected container.

  With dynamic protection, any new databases or assets that you add to the instance or AAG or container after the policy is created or edited will be automatically added to the protection policy. Any databases or assets that you remove from the instance or AAG or container are also removed from the policy. When any selection overlap occurs between different policies, the UI displays the overlaps and helps you to resolve the asset assignment conflicts by adjusting the protection rules' priority.

  To disable the dynamic protection for a container, click and then click Disable in the displayed text box. When the dynamic protection is disabled, the protection policy does not dynamically protect the selected container and its objects. As a result, all the selected objects within the container become static selections that are not automatically protected by the policy.

  After you create or edit a protection policy that has dynamic protection, you can select Protection > Protection Rules to see the protection rule details for the protection policy, including the priority of the protection rule. Dynamic protection rules apply only at the container level.

• AAG Selection ()—This icon appears when the selected host or instance includes one or more AAGs. By default, the icon is enabled and all the AAGs within the host or instance are selected. When you want to exclude all the contained AAGs from the protection policy, click and then click Exclude in the displayed text box.

In the hierarchical view, you might see in the Protection Policy column, next to a selected host, instance, database, or AAG to indicate that one of the following issues exists. Hover over to see the issue description:

• When the Microsoft application agent version is earlier than 19.9, an AAG folder might display an incomplete hierarchical view of the data. To obtain a complete view of the data, update the Microsoft application agent. Version 19.9 is not supported.
• An asset assignment conflict exists because the host, instance, or contained object is already protected by another protection policy. After you click Next on the Assets page and click OK on a notification page, the Check conflicts due to rule priority page appears, where you can adjust the protection rule priorities and resolve the conflicts.

For exclusion policies, the wizard moves to the Summary page. Continue to Review the protection policy summary.

For all other policy purposes, the wizard moves to the Objectives page. Continue to Add protection policy objectives.