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

Import the Policies to a Single Instance

In this task, you will import the best practices policies that you want to schedule into Policy-Based Management on a single instance of SQL Server.

You must perform this procedure on a server that is running SQL Server 2008 or a later version.

Import the best practices policies for the Database Engine

  1. Start SQL Server Management Studio, and then connect to the Database Engine.

  2. In Object Explorer, expand Management, and then expand Policy Management.

  3. Right-click Policies, and then click Import Policy.

  4. In the Import dialog box, next to the Files to import box, click the ellipsis () button.

  5. In the Look in list, browse to the following folder, which contains the best practices policies:

    C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Policies\DatabaseEngine\1033

    Note Note

    The file path may vary, depending on where you installed the SQL Server program files, whether you are running a 32-bit or 64-bit operating system, and the language identifier.

  6. In the Select Policy dialog box, select one or more policy files.

    To select nonadjacent files, click one file, hold down the CTRL key, and then click each additional file. To select adjacent files, click the first file in the sequence, hold down the SHIFT key, and then click the last file.

  7. When you are finished selecting files, click Open.

  8. In the Import dialog box, make sure that the Policy state list is set to Preserve policy state on import (the default), and then click OK.

    The policies are imported into the Policies node under Policy Management. By default, the imported policies are set to "On demand" evaluation mode.

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

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.