Skip to content

import-a-policy-based-management-policy.md

Latest commit

 

History

History
39 lines (27 loc) · 1.81 KB

import-a-policy-based-management-policy.md

File metadata and controls

39 lines (27 loc) · 1.81 KB
title Import a Policy-Based Management Policy
description Import a Policy-Based Management Policy
author VanMSFT
ms.author vanto
ms.date 08/06/2020
ms.service sql
ms.subservice security
ms.topic how-to
helpviewer_keywords
Policy-Based Management, import policy

Import a Policy-Based Management Policy

[!INCLUDE SQL Server] This topic describes how to import a Policy-Based Management policy instance in [!INCLUDEssnoversion] by using [!INCLUDEssManStudioFull].

Permissions

Requires membership in the PolicyAdministratorRole role in the msdb database.

Using SQL Server Management Studio

To import a policy instance

  1. In Object Explorer, click the plus sign to expand the server where the newly-imported policy instance will reside.

  2. Click the plus sign to expand the Management folder.

  3. Click the plus sign to expand Policy Management.

  4. Right-click the Policies folder and select Import Policy.

  5. 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. For more information on the available options in the Import dialog box, see Import Policies Dialog Box.

  6. When finished, click OK.

Example policies

Example policies are available in the SQL Server Samples code repository. These policies can be imported and used as a basis for your own policy-based management policies.