Databases Reference
In-Depth Information
18
Policy-based
Management
In this chapter we will cover:
F
Evaluating database properties
F
Restricting database objects
Introduction
Microsoft made database administrators very happy by introducing a feature called
Policy-based Management (PBM). PBM helps administrators to manage one or more
instances of SQL Server and manage database entities and/or other SQL Server objects,
based on the policy defined in PBM. It helps DBAs to apply/enforce policies for server
objects and databases, or to manage different tasks effortlessly and effectively.
The following terms will be needed in the recipes coming up in this chapter, so keep them in
mind to ensure that you can understand all the recipes properly:
F
Policies: Defined rules for the database or server objects under Policy-Based
Management
F
Conditions: A condition is a Boolean value that shows the status of facets
Search WWH ::
Custom Search