Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

How to: Export and Import a Policy-Based Management Policy

Policy-Based Management policies are installed on an instance of the SQL Server Database Engine. A policy with its condition can be exported to an XML file, and imported from an XML file to another instance of SQL Server.

This topic demonstrates how to export a policy and then import a policy.

To export a Policy-Based Management policy

  1. In Object Explorer, expand Management, expand Policy Management, Policies, right-click a policy, and then click Export Policy.

  2. In the Export 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.

  3. Click Save.

To import a Policy-Based Management policy instance

  1. In Object Explorer, expand Management, expand Policy Management, right-click Policies, and then click Import Policy.

  2. In the Import dialog box, type the path and name of the file; or use the Browse (...) button to locate the XML file that contains the policy, and then select the file.

  3. Click Open and then click OK.

    NoteNote

    SQL Server ships with policies that can be used to monitor an instance of SQL Server. By default, these policies are not installed on the SQL Server Database Engine, but they can be imported from the default location of C:\Program Files\Microsoft SQL Server\100\Tools\Policies\DatabaseEngine\1033.

Requires membership in the PolicyAdministratorRole role in the msdb database.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.