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.



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

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net