Skip to content

copy-a-policy-based-management-facet-state-to-an-xml-file.md

Latest commit

 

History

History
46 lines (30 loc) · 2.01 KB

copy-a-policy-based-management-facet-state-to-an-xml-file.md

File metadata and controls

46 lines (30 loc) · 2.01 KB
title Copy a Policy-Based Management facet state to XML File
description Describes how to copy the state 0f a Policy-Based Management facet to an XML file using SQL Server Management Studio (SSMS).
author VanMSFT
ms.author vanto
ms.date 03/14/2017
ms.service sql
ms.subservice security
ms.topic how-to
helpviewer_keywords
Policy-Based Management, copy facet state to XML file

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

[!INCLUDE SQL Server] This topic describes how to how to copy the state of a Policy-Based Management facet to an XML file in [!INCLUDEssnoversion] by using [!INCLUDEssManStudioFull].

In This Topic

Before You Begin

Security

Permissions

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

Using SQL Server Management Studio

To copy a facet state to an XML file

  1. In Object Explorer, right-click an instance of [!INCLUDEssNoVersion], 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.