Working with Policy-Based Management Facets

Working with Policy-Based Management Facets

 

Applies To: SQL Server 2016

A Policy-Based Management facet is a set of logical properties that are related to an area of management interest. SQL Server includes several predefined facets. For example, the Surface Area Configuration facet defines, as properties, the features that are off by default.

When you manage many similar SQL Server environments, you can configure a facet in one instance of SQL Server, copy the state of the facet to a file, and then import that file into another instance of SQL Server as a policy. When the state has been converted to a policy, the policy can be applied to other instances of SQL Server, instance objects, databases, or database objects.

This topic describes how to copy the state of a facet to an XML file.

The procedures in this topic require membership in the PolicyAdministratorRole role in the msdb database.

View the Policy-Based Management Facets on a SQL Server Object

Copy a Policy-Based Management Facet State to an XML File

Administer Servers by Using Policy-Based Management

Community Additions

ADD
Show:
© 2016 Microsoft