- Policy-based management provides a method of managing more than one instance across multiple servers.
- We can use policy-based management to manage instances, databases, and other objects such as backup devices.
- We can use policies to enforce configuration standards such as blocking anyone from enabling Auto Shrink and Auto Close on databases
EXAM TIP There is an existing policy named Database Auto Shrink that you can use instead of creating your own.
- To work with policy-based management, a principal must be a member of the PolicyAdministratorRole database role in the msdb database.
- Policy information is stored in the msdb database
- We can transfer policies between instances by using the import and export functionality
- We can also configure a central management server and have the policies on one instance apply directly to other instances
We use the following objects to configure policy-based management:
- Facet - A collection of properties that can be configured.
- Condition – The settings that can be configured for the property. Available conditions depend on the properties of a facet.
- Policy - A condition that should be enforced. Blocking Auto Shrink from being enabled on databases could be one policy; blocking Auto Close on databases could be another.
- Category - A collection of categories that should be enforced
- Target - Defines the scope of policy application. It can include instances, databases, or database objects.