Designing Policy Based Management in Microsoft SQL Server 2008

  • 2/18/2009
Contents

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.

Save to your account

This chapter is from the book