Chapter 17. Database Maintenance

by Paul Jensen

IN THIS CHAPTER

• What Needs to Be Maintained

• The Database Maintenance Plan Wizard

• Setting Up Your Own Maintenance Tasks

• The Database Console Commands (DBCC)

• Using SQLMAINT.EXE for Database Maintenance

Database administration doesn't stop after the database is created. On the contrary, ongoing maintenance tasks must be performed to maintain data integrity and keep the database performing smoothly. This chapter looks at some of the tasks related to database maintenance, and the tools?in particular the Database Maintenance Wizard?that will help you perform your maintenance chores.