Managing Policies Throughout the Enterprise
As discussed previously, you create and manage policies in SQL Server Management Studio. Implementing Policy-Based Management is a multistep process that involves selecting a facet that contains the properties you want to configure, defining a condition that specifies the permitted states of the facet, and defining a policy that contains the condition and sets an evaluation mode. The evaluation mode you set determines whether SQL Server uses automated policy monitoring, reporting, and compliance enforcement.
Importing and Exporting Policies
SQL Server 2008 includes predefined policies for the Database Engine, Analysis Services, and Reporting Services. You can import these predefined policies with their ...