From the course: SQL Server 2012: Designing Database Solutions

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Extending policy-based management to repair problems

Extending policy-based management to repair problems - SQL Server Tutorial

From the course: SQL Server 2012: Designing Database Solutions

Start my 1-month free trial

Extending policy-based management to repair problems

- In this section, I'd like to show an example of using policy management to correct some problems on our SQL Server. In previous examples, we saw how policy management can help us find problems on the SQL Server, and really if the tool did just that, it would still be a great tool, but the tool can go beyond that, and in some cases it can help us not only find the problem but also correct the problem. To do this we'll need to create a new condition. The facet I'm interested in is Database. Now I'm interested in the field AutoShrink. Some DBAs really like AutoShrink. Some DBAs really don't like AutoShrink. I'm not going to get into that debate right now. I'm just going to say, for purposes of this example, I would like AutoShrink to be set to true on all of my databases. So I will test for, is it equal to true, and I'll need to give this a name. I'll just call it AutoShrink and hit okay. Then we'll create a new Policy based on that condition. So the Check condition is AutoShrink. I'll…

Contents