Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

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

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

This topic describes how to how to copy the state of a Policy-Based Management facet to an XML file in SQL Server 2016 by using SQL Server Management Studio.

In This Topic



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

Arrow icon used with Back to Top link [Top]

To copy a facet state to an XML file

  1. In Object Explorer, right-click an instance of SQL Server, instance object, database, or database object, and then click Facets.

  2. In the View Facets – object_name dialog box, click Export Current State as Policy.

  3. In the Export as Policy dialog box, type the path and name of the file; or use the Browse (...) button to locate the file, and then type the name of the XML file. For more information on the available options in this dialog box, see Export As Policy Dialog Box

  4. When finished, click OK.

Arrow icon used with Back to Top link [Top]

Community Additions

© 2015 Microsoft