Enabling this icon (enabled by default), automatically creates a dynamic protection rule to ensure that all the selected assets within the selected host or instance container are dynamically protected by the protection policy. Data Manager manages the protection rule. Any of the following actions updates the rule: editing the policy, making changes to the container selections, or moving assets into or out of a selected container.
After creating or editing the policy, dynamic protection ensures that any new databases, or assets that are added to the instance or AAG or container, are added automatically to the protection policy. Removing any databases or assets from the instance or AAG or container also removes them from the policy. When any selection overlap occurs between different policies, the UI displays the overlaps and helps to resolve the SQL asset assignment conflicts by adjusting the protection rules' priority.
To disable the dynamic protection for a container, click the Dynamic Protection icon 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 the policy does not automatically protect.
After creating or editing a protection policy that has dynamic protection, go to 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.