Configure and Manage Policy Based Management in SQL Server 2008

2. In the Object Explorer, Click on Management ? Policy Management and you will be able to see Policies, Conditions & Facets as child nodes 3. Click on Facets Node and expand it to see 74 predefined set of SQL Server Facets which are useful when you want to create policies for SQL Server 2008 4. Double Click on Database Maintenance Facet to see all the properties that can be managed when we create a policy using this facet How to Create a Condition
In Policy Based Management the initial step is to create a condition. New conditions can be created by right clicking the Conditions child node under Management | Policy Management. 
Once the Create New Condition popup window opens, you need to provide the Name, Facet and the Expression values as shown in the image below. In this condition we are setting an expression that all the databases on the current SQL Server 2008 Instance should have the Recovery Model configured as FULL

Continues…

Leave a Reply

Your email address will not be published. Required fields are marked *