Chapter 3. Evaluating Policies

Evaluating a policy is the process of executing a policy and reviewing the results against the desired configuration on the target instance. Policy-Based Management provides several options and configurations for evaluating policies:

  • You can evaluate policies against a single registered SQL Server instance or a group of instances.

  • You can configure policy evaluation to check on change, on schedule, or on demand.

  • You can configure Policy-Based Management to allow and log the noncompliant changes, or to prevent and roll back changes.

  • You can schedule evaluation of single or multiple policies against a given SQL Server instance.

All of these techniques will be covered in this chapter.

Evaluation Modes

As discussed in the previous ...

Get Pro SQL Server 2008 Policy-Based Management now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.