error 824 severity 24 state 2 trying to attach database

Question

error 824 severity 24 state 2 trying to attach database

sqldriver

SSChampion

Points: 10440
More actions
April 24, 2014 at 8:08 pm

#306779

Got this trying to restore a DB from archive. What are my options? You can ignore the part about the .ldf, that was just my last attempt to attach the db without the log. DB won't attach via GUI, but maybe one of you lovely, lovely people knows a command that will get it to attach so I can run check db on it.
Thanks

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

Do you have access to any backups for the database? You may need to see if you have a good backup prior to the database becoming corrupt.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

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

sqldriver SSChampion Points: 10440 More actions · Answer 3

If I had one, that's what I'd do. This was an old backup whose data got aged out after the mdf and ldf were moved to archive.

I'll check that link out and see if I can do anything with it.

Thanks

sqldriver SSChampion Points: 10440 More actions · Answer 4

That didn't work either. Thankfully the archival process is confused enough that there was another copy of the mdf and ldf sitting around in another batch. :w00t: