Lesson 1: Create and Apply an Off By Default Policy

Using Policy-Based Management policies, you can administer one or more instances of SQL Server, one or more instance objects, server instances, one or more databases, or one or more database objects. As the database administrator, you want to ensure that certain servers do not have either Database Mail or SQL Mail enabled. In this lesson, you will create a condition and a policy that sets those server options. You will test the server to see whether it complies with the policy. Then, you will use the policy to reconfigure the server to bring the server into compliance.

This lesson contains the following topics:

• Create the Off By Default Policy

• Configure a Server to Run the Off By Default Policy

Next Task in Lesson

Create the Off By Default Policy

Next Lesson

Lesson 2: Create and Apply a Naming Standards Policy