Chapter 17. Database Maintenance

by Paul Jensen


  • 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.

    Part III: SQL Server Administration
    Part IV: Transact-SQL
    Part V: SQL Server Internals and Performance Tuning
    Part VI: Additional SQL Server Features