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.

Microsoft SQL Server 2000 Unleashed
Microsoft SQL Server 2000 Unleashed (2nd Edition)
ISBN: 0672324679
EAN: 2147483647
Year: 2002
Pages: 503

Similar book on Amazon © 2008-2017.
If you may any questions please contact us: