SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond

Chapter Essentials

Policy-Based Management PBM is the new term for DMF, or you might say that PBM implements the DMF. PBM is based on facets that are controlled by conditions, which are evaluated by policies. Policies can use one of four evaluation modes including On Demand, On Schedule, On Change:Log Only, and On Change:Prevent. The facet will dictate which evaluation modes may or may not be utilized.

Centralized Server Management A CMS can be used to centrally control or manage multiple server instances. The CMS can manage both local instances and remote server instances. You begin using centralized management by registering a CMS and then registering servers with the CMS. You can place servers in server groups so that they may be managed as ...