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
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.