Export a Policy-Based Management Policy

THIS TOPIC APPLIES TO: yesSQL ServernoAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

This topic describes how to export a Policy-Based Management policy in SQL Server 2017 by using SQL Server Management Studio.

In This Topic

Before You Begin



Requires membership in the PolicyAdministratorRole role in the msdb database.

Using SQL Server Management Studio

To export a policy

  1. In Object Explorer, click the plus sign to expand the server that contains the Policy-Based Management policy that you want to export.

  2. Click the plus sign to expand the Management folder.

  3. Click the plus sign to expand Policy Management.

  4. Click the plus sign to expand the Policies folder.

  5. Right-click the policy that you want to export and select Export Policy.

  6. In the Export Policy dialog box, type the path and name of the file in the address bar. Alternately, find a suitable location for the file in the dialog box's navigation pane, and then type the name of the XML file in the File Name box.

  7. When finished, click Save.