545
Chapter 20: Policy Based Management
20
FIGURE 20-8
Here the Aesop database passes the No AutoShrinkage policy and declares to be in good
health.PBM requires SQL Server Agent running on the central monitoring server. Be sure the SQL Server Agent service is set
to start automatically and that its service account password won’t expire.Summary
Policies — if you’re an operational DBA, they can change your world. IT database opera-
tions are more consistent, and your life should become smoother. Indeed, Policy-Based
Management (PBM) is a completely new animal, and it will take some time to build up a set
of good conditions and policies, but when it’s all put together, it will have been worth it.Chapter 21, “Backup and Recovery Planning,” continues the thread of database administra-
tion with the nuts and bolts or backup and restore.c20.indd 545c20.indd 545 7/30/2012 5:45:20 PM7/30/2012 5:45:20 PM
http://www.it-ebooks.info