• Might be able to hack something out with enough work and fiddling that might allow for repair to throw data away, but restore from backup should be one of the first plans for corruption in most cases, with more creative solutions for when there are no backups.

    Do you have recovery_pending or offline files? If so, then there's no choice but restore unless you want to lose everything in those files.

    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