O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Importing and Exporting Policies

In some situations a DBA might want to export one or many policies with their conditions from one or many SQL Server systems and import them to another SQL Server instance or system. Fortunately, you can perform this task easily with an export and import wizard that generates or reads the policy definitions as XML files.

Follow these steps to export a policy with SQL Server Management Studio:

1. In Object Explorer, expand the Management folder, expand the Policy Management node, and then expand the Policies folder.

2. Within the Policies folder, right-click a desired policy to export and then select Export Policy.

3. In the Export Policy dialog, specify a name and path for the policy and click Save.

Importing ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required