GilaMonster (5/7/2014)
TheSQLGuru (5/7/2014)
But given the extent of the problem (pun intended 😛 ) I doubt it is from the shutdown itself, or even multiple unexpected shutdowns.I'm not willing to guess without a lot more information. There's no where near enough detail for me to make an accurate diagnostic or prediction.
Fair enough, although I do not consider my doubt/assertion a true guess and certainly not a random guess. It is a probabilistic analysis of information (i.e. LOTS of corruptions mentioned multiple times) that I believe is sufficient to rule out a particular cause the (vast?) majority of the time.
Also note that you stated that 9,999 times out of 10,000 that the IO subsystem was responsible for corruptions. Same type of probabilistic statement - just with a higher level of certainty. 😎
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service