dbcc checkdb - things you find

I was sorting out some corruption in a database , error 8966 for the curious, which was preventing a backup occuring which is always bad news.

I just happened to run across the option  ESTIMATEONLY which gives an idea of how much tempdb space is required for a checkdb, use as  dbcc checkdb with estimateonly returns the estimated space for  CHECKALLOC and CHECTABLE(s) learn something new every day!!!

Published 21 September 2006 10:37 by GrumpyOldDBA
Filed under:

Comments

No Comments