Share via

  • Article

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.

Prerequisites

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\Microsoft SQL Server\100\Tools\Policies\DatabaseEngine\1033

    Note

    The file path may vary, depending on where you installed the SQL Server program files, 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.