• Can you get the DB into Emergency mode at all?

    ALTER DATABASE HealthBookDB Set Emergency

    GO

    If so, can you query any tables while it's in Emergency mode?

    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