• One thing you can do (assuming you have disk space) is restore the database to another location and then run DBCC on that. There are a few types of errors that won't get picked up in that way, but all the internal consistency errors will be, and those are the ones that occur most frequently. Offloading DBCC through a secondary server is a very common practice to help reduce the load on the production machine.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning