- By Mike Hotek
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.