August 2012
Intermediate to advanced
1416 pages
33h 39m
English
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 maintenance 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.
Read now
Unlock full access