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 first published in May 2005

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

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close