Home

	Expand Search

System Administration Guide (Online Only)

Chapter 25 Checking Database Consistency

Chapter 25

Checking Database Consistency

This chapter describes how to check database consistency and perform some kinds of database maintenance using the dbcc commands.

What is the database consistency checker?

Understanding page and object allocation concepts

Understanding the object allocation map (OAM)

Understanding page linkage

What checks can be performed with dbcc?

Checking consistency of databases and tables

dbcc checkstorage

dbcc checktable

dbcc checkdb

Checking page allocation

dbcc checkalloc

dbcc indexalloc

dbcc tablealloc

Correcting allocation errors using the fix | nofix option

Generating reports with dbcc tablealloc and dbcc indexalloc

Checking consistency of system tables

Strategies for using consistency checking commands

Comparing the performance of dbcc commands

Using large I/O and asynchronous prefetch

Scheduling database maintenance at your site

Understanding the output from dbcc commands

Errors generated by database consistency problems

Comparison of soft and hard faults

Verifying faults with dbcc checkverify

How dbcc checkverify works

When to use dbcc checkverify

How to use dbcc checkverify

Dropping a damaged database

Preparing to use dbcc checkstorage

Planning resources

Configuring Adaptive Server for dbcc checkstorage

Creating the dbccdb database

Updating the dbcc_config table

Maintaining dbccdb

Reevaluating and updating dbccdb configuration

Cleaning up dbccdb

Removing workspaces

Performing consistency checks on dbccdb

Generating reports from dbccdb

To report a summary of dbcc checkstorage operations

To report configuration, statistics and fault information

To see configuration information for a target database

To compare results of dbcc checkstorage operations

To report faults found in a database object

To report statistics information from dbcc_counter