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 ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.