Designing Policy Based Management in Microsoft SQL Server 2008

  • 2/18/2009

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.