Home > Sample chapters

Designing Policy Based Management in Microsoft SQL Server 2008

Suggested Practices

To help you master the exam objectives presented in this chapter, complete the following tasks.

Implement Policy Based Management

  • Practice 1 Configure a policy to check the surface area configuration for all your SQL Server instances.

  • Practice 2 Configure a policy to check the last time a database was successfully backed up.

  • Practice 3 Configure policies to check the membership of the sysadmin and db_owner roles.

  • Practice 4 Configure a policy to ensure that databases are not set to either auto shrink or auto close.

  • Practice 5 Based on the policies that ship with SQL Server 2008, decide which policies apply to your environment and implement the policy checks.