Chapter 11. Developing a SQL Server Maintenance Plan
by Orryn Sledge
IN THIS CHAPTER
Areas of Maintenance
Maintenance Checklist
Maintenance FAQ
Developing a SQL Server maintenance plan is a proactive approach that can help minimize system downtime. SQL Server 2000 has greatly simplified database maintenance, however, I still like to compare SQL Server to a car. Both require preventive maintenance and periodic tune-ups. To help you keep SQL Server motoring along, this chapter discusses the types of maintenance that should be performed by a DBA. To learn how to automate several of the tasks discussed in this chapter, see Chapter 12, “Automating Database Administration Tasks.”
NOTE
Starting with SQL Server 7.0, the product became significantly better ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.