The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P62: Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008. | Maintaining Your Database Chapter 7 287 The configuration of maintenance plans is stored in MSDB also. Again you must back up MSDB to avoid the risk of losing your maintenance plan configuration. To configure Maintenance Plans expand Management right-click Maintenance Plans and then click Maintenance Plan Wizard. To view the execution history of a particular maintenance plan right-click on it in the Object Browser then click View History. Policy-Based Management Many database administrators work for large organizations that keep many SQL Servers for example a customer organization that maintains over 50 SQL Servers in different locations. As you can imagine it is difficult to report on and apply configuration changes to that many servers individually. Keeping the configuration standardized becomes a laborious task and with individual management mistakes are inevitable. This is why the Policy-Based Management feature has been introduced in SQL Server 2008. Policy-Based Management allows you to view and configure settings on multiple instances of SQL Server 2008. Using Policy-Based Management you can apply a configuration change to a group of servers with one administrative action. Furthermore Policy-Based Management allows you to enforce standards on your SQL Server for example object naming standards. This is known as Explicit Administration. SQL Server Management Studio provides PolicyBased Management wizards. These are accessible from the Object Browser under Management Policy Management. Let s examine the key components of Policy-Based Management and how they relate to each other Managed targets are the objects you will be managing with Policy-Based Management. Instances of SQL Server databases tables indexes and other database objects can be targeted for Policy-Based Management. Targets are presented in a logical hierarchy. You can create target sets by filtering all managed targets using a filter criterion for example all database names starting with MOSS_ or
