Home Forums SQL Server 2008 SQL Server 2008 Administration error 824 severity 24 state 2 trying to attach database RE: error 824 severity 24 state 2 trying to attach database

  • April 25, 2014 at 1:33 am

    #1708688

    I'd second the 'restore from last good backup', but might be possible to hack-attach the database. Last resort though.

    http://www.sqlskills.com/blogs/paul/disaster-recovery-101-hack-attach-a-damaged-database/

    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