Lempster (8/6/2014)
Are you sure about that Gail?
Yes, absolutely, 100% certain
Below is an extract from a SQL Server log at the time a database was recovered from a Restoring state. I can assure you that the CHECKDB shown was not run by anyone or a scheduled job.
And I can assure you that checkDB wasn't run at all...
07/31/2014 22:04:40,spid54,
Unknown,CHECKDB for database 'BrightTalk' finished without errors on 2012-06-25 01:00:04.770 (local time).
In fact, that database has not had a consistency check run on it in over 2 years. I do hope it's a dev DB...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability