Chapter 28. Database Maintenance

IN THIS CHAPTER

Database maintenance is an essential part of database administration that is needed to keep databases healthy. It includes tasks that are performed after your database is created to ensure the integrity of the data in the database, provide performance improvements, and help keep the database safe.

This chapter examines some of the key tasks that should be included in your database maintenance plan. It discusses the means for creating these plans, including tools such as the Maintenance Plan Wizard that is part of SQL Server 2005. ...

Get Microsoft® SQL Server 2005 Unleashed 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.