Tutorial: Administering Servers by Using Policy-Based Management

This tutorial creates a policy to administer your server and a policy that applies to a single database. One policy is run on demand to test for compliance. The other policy enforces future compliance.

This tutorial is divided into two lessons:

Lesson 1: Create and Apply an Off By Default Policy

This lesson creates a policy that specifies that both Database Mail and SQL Mail are not enabled on the server. Then, it checks to see whether your server complies with the policy, and configures the server by disabling those features.

Lesson 2: Create and Apply a Naming Standards Policy

This lesson creates a policy that defines and enforces a naming standard for tables.

This lesson requires basic database knowledge and a basic understanding of SQL Server Management Studio.

To use this tutorial, your system must have SQL Server Management Studio installed.

Note
When you are reviewing tutorials, we recommend that you add Next and Previous buttons to the document viewer toolbar. For more information, see Adding Next and Previous Buttons to Help.

Lesson 1: Create and Apply an Off By Default Policy

Concepts