Eksportér (0) Udskriv
Udvid alt
Dette indhold er ikke tilgængeligt på dit sprog, men her er den engelske version.

Lesson 2: Evaluate Best Practices Policies on a Scheduled Basis

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

You can configure scheduled evaluations of best practices policies on one or more instances of SQL Server. To configure best practices policies to run on a scheduled basis, you must import the policies into the target instance.

To deploy scheduled policies to multiple servers, you can import the policies to one instance, configure the schedules for each policy, export the scheduled policies to a folder, and then deploy the scheduled policies to target instances through Registered Servers.

Important note Important

The target instances must be running SQL Server 2008 or a later version. Automation requires the policies to be stored locally on the instance, which is not supported by versions of SQL Server that are earlier than SQL Server 2008.

In this lesson, you will do the following:

  • Import the best practices policies into an instance of SQL Server.

  • Configure the policies to run on a schedule.

  • Deploy the scheduled best practices policies to multiple instances through Registered Servers.

This lesson contains the following topics:

Syntes du, dette var nyttigt?
(1500 tegn tilbage)
Tak for din feedback


© 2015 Microsoft