henrik staun poulsen (3/14/2013)
Hi Steve,We also almost never run CHECKDB.
This is because it takes tooooooo long.
I'm taking something above 50 hours.
When we restore a backup onto our test system, the normal procedure is to run CHECKDB, if time permits.
I would like to be able to run something that does the same thing as CHECKDB, but concurrently with the normal daily processing.
Do you know of such a thing?
Best regards,
Henrik Staun Poulsen
Stovi Software
You can run physical only, which does some checks, but not all of it.
The only solution is to really get a good second box and throw some horsepower on it. I'd try to run it every week.
The other thing which is a "cheap" check, but is semi-safe for me, is to run a SELECT * from all tables and if they all complete, at least you have all your data accessible.