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

  • Run SP_configure and set allow updates to 1. Update sysdatabases for that database and set the status to 32767.

    Then see if you can access the DB and run checkdb. Not repair, just with the no_infomsgs and all_errormsgs options.

    There's far more wrong here than just a suspect DB. You've got access violations all over the error log. This is one sick server. I'd suggest calling CSS, but SQL 2000 is out of support so they won't help you.

    Your also running on a very low service pack of SQL 2000. SQL 8.0.818. Offhand I don't know what service pack that is, but it's not the last one available. I strongly suggest you patch that server to the latest service pack and consider an upgrade to 2008.

    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