Summary
This chapter covered database maintenance in detail. SQL Server offers a rich set of
commands and utilities that you can use to monitor the health of, and perform mainte-
nance on, SQL Server. The Maintenance Plan Wizard is also available to streamline database
maintenance. All installations of SQL Server should also include a database maintenance
schedule to assist the DBA in keeping track of maintenance performed.The next chapter explains how to use SQL Agent, which you can use to schedule jobs and
create custom maintenance jobs and Database Mail to send e-mails from SQL Server.c22.indd 614c22.indd 614 7/31/2012 9:24:34 AM7/31/2012 9:24:34 AM
http://www.it-ebooks.info