[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 
Policy Based Management

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
Tips
Troubleshooting
Tuning

Policy Based Management - Enforcing Recovery Model Full

Applies: SQL Server 2008 (Katmai) CTP November 2007



Microsoft SQL Server 2008 introduces Declarative Management, which delivers the following benefits:
 

bulletEnsures compliance with policies for system configuration
bulletMonitors and prevents changes to the system by authoring policies against the configuration
bulletReduces total cost of ownership by simplifying administration tasks
bulletDetects compliance issues in SQL Server Management Studio


Let's use the Declarative Management Framework to enforce a recovery model full on each database attached to an specific instance of SQL Server 2008:


1. In Object Explorer, expand Management, expand Policy Management and then expand Conditions.
 



2. Locate the condition named "Recovery Model Full", and double click on it to see how it was created, and then close the window.
 




3. In Object Explorer, right-click Policies, and then click New Policy.

 



4. In the Create New Policy dialog box, in the Name box, type DBA - Enforce Recovery Model Full.

 



5. Select the condition named "Recovery Model Full".


 




6. Specify how the policy will be executed. Select the execution mode "On schedule"



 




7. Create a new job schedule and click OK

 



8. Select the Enabled box and click OK.

 



 



As you will see, the procedure we just completed created a new job for SQL Server Agent
 




Now let's test our policy.




 




To make all databases comply with the policy, make a click on the "Configure" button.





 

 

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.