This topic describes how to export a Policy-Based Management policy in SQL Server 2017 by using SQL Server Management Studio.
In This Topic
Requires membership in the PolicyAdministratorRole role in the msdb database.
To export a policy
In Object Explorer, click the plus sign to expand the server that contains the Policy-Based Management policy that you want to export.
Click the plus sign to expand the Management folder.
Click the plus sign to expand Policy Management.
Click the plus sign to expand the Policies folder.
Right-click the policy that you want to export and select Export Policy.
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.
When finished, click Save.