Export a Policy-Based Management Policy

Applies to: SQL Server

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

In This Topic

• Before you begin:

  Security

• To export a policy, using:

  SQL Server Management Studio

Before You Begin

Security

Permissions

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.