Database consistency checker

It is important to run database consistency checks periodically with dbcc. If you back up a corrupt database, the backup is useless. But dbcc affects performance, since dbcc must acquire locks on the objects it checks.

See the System Administration Guide for information about dbcc and locking, with additional information about how to minimize the effects of dbcc on user applications.