• Corruption is 99.99% IO subsystem problem. Not necessarily the disks, could be anything anywhere in the IO stack.

    Since you mentioned an uncontrolled shutdown, I'd check and make sure all write caches are battery-backed (with working batteries) or disabled.

    Without seeing the full results of a CheckDB (not one run with repair), it's very, very hard to say more. There's not enough information.

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass