Home Forums SQL Server 7,2000 Data Corruption DB corrupted with event 17052 and Error: 823, Severity: 24, State: 2 RE: DB corrupted with event 17052 and Error: 823, Severity: 24, State: 2

  • September 12, 2011 at 4:42 pm

    #1380361

    halifaxdal (9/12/2011)

    GilaMonster (9/12/2011)

    Did someone detach or drop the DB? Only reasons it wouldn't be in sysdatabases.

    i don't know, the guy did tell me he saw it was marked as suspect

    A suspect database still appears in sysdatabases. If it's not in sysdatabases it's been detached or dropped and there's absolutely nothing that can be done unless you can find the files for that database.

    If the DB has been dropped, it's gone.

    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