Chapter Download: Essential SQL Server 2000 maintenance

This chapter from the book, Essential SQL Server 2000, by Buck Woody discusses two types of maintenance tasks: tasks that keep the database going and tasks that keep the database going fast

The most important and least glamorous tasks a DBA performs are those that involve maintenance. It's the kind of thing that if you do it, nobody notices; but if you don't, everybody knows. This chapter from the book, Essential SQL Server 2000, by Buck Woody discusses two types of maintenance tasks: tasks that keep the database going and tasks that keep the database going fast.

The primary tool described here for database maintenance is the Database Maintenance Wizard. This graphical tool walks you through setting up a scheduled plan that can include integrity checks, optimizations, and backups. The second set of tools are the T-SQL Database Consistency Check (DBCC) commands. They perform maintenance tasks on a database or an index, as well on filegroups.

Click here to download this free book chapter.

Click here for more information on Addison-Wesley Professional, the author, or to buy the book.

This was last published in May 2005

Dig Deeper on SQL-Transact SQL (T-SQL)

PRO+

Content

Find more PRO+ content and other member only offers, here.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close