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 for more information on Addison-Wesley Professional, the author, or to buy the book.