Database consistency checker

Periodically, use dbcc to run database consistency checks. If you back up a corrupt database, the backup is useless. dbcc affects performance, since dbcc must acquire locks on the objects it checks.

See Chapter 10, “Checking Database Consistency” in the System Administration Guide: Volume 2 for information about dbcc and locking, with additional information about how to minimize the effects of dbcc on user applications.