• You're welcome to feel that way.

    Do note that I'm not talking in ignorance here. I know a reasonable amount about corrupt databases and recovering them. I could point you to a blog post by the person who wrote DBCC CheckDB where he explains about emergency mode and what it means if the emergency mode log rebuild fails. (I could also ask him for a second opinion if you like, but he's on vacation for the next two weeks)

    You may be able to extract data from the DB after setting it to emergency, even without the rebuild log succeeding. If you can, it may an option to extract what you can and recreate the database.

    What error was the log rebuild giving?

    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