tailieunhanh - Brad’s Sure Guide to SQL Server Maintenance Plans- P4

Brad’s Sure Guide to SQL Server Maintenance Plans- P4: SQL Server has a reputation as being a simple database application to install, configure, and maintain. This is a little misleading. SQL Server is a powerful relational database that can handle the needs of the largest organizations and, as such, its proper maintenance almost certainly requires the attention of an experienced DBA. | Goals of this Book As 1 cover how to use the Maintenance Plan Wizard and Maintenance Plan Designer in this book 1 have tried to keep the following goals in mind to keep the book at a level that most non-professional DBAs can understand not only to cover the mechanics of how to use the Maintenance Plan Wizard and Maintenance Plan Designer but also to offer practical advice on how best to maintain your databases to provide an easy-to-read tutorial approach to learning to offer lots of best practices from the real world. SQL Server Editions Covered in this Book This book covers the use of the Maintenance Plan Wizard and the Maintenance Plan Designer for SQL Server 2005 and SQL Server 2008 including both the Standard and Enterprise editions. 1f you are running SQL Server 2005 you should be on Service Pack 2 or later as Service Pack 2 introduced some changes in the Maintenance Plan Wizard and Maintenance Plan Designer which make it closer in functionality to SQL Server 2008. All the screenshots and examples are from SQL Server 2008 which on occasion varies from SQL Server 2005. When there are significant differences 1 will point them out. SQL Server 2000 and earlier is not covered because Maintenance Plans changed substantially between SQL Server 2000 and SQL Server 2005. Although the implementation changed quite a bit the database maintenance recommendations 1 make in this book still apply to SQL Server 2000 and earlier. 16 Chapter 1 Why is Database Maintenance Important More times than I can count I have seen a company install SQL Server databases without first creating any form of maintenance plan. These servers hum merrily along with nary a problem. That is until there is a problem. At this point query performance drops drastically or servers run out of disk space or in extreme cases databases become corrupt. And oh by the way nobody ever bothered to set up a backup plan so there are no backups to restore. Oops The goal of implementing a database maintenance plan is