Post reply

A Logical Consistency-Based I/O Error

  • August 30, 2017 at 9:50 am

    #148061

    Hi all,
    Here's my problem:
    I cannot connect tp SQL Server. Getting this error message:
    Sql Server Detected A Logical Consistency-Based I/O Error: Incorrect Checksum. (Microsoft SQL Server, Error:824)

    Any thoughts please?
    Thanks

     

  • August 30, 2017 at 10:00 am

    #1957502

    Speak to your DBA. That's a pretty severe problem, but they'll have to connect and get detailed info about the error to figure out where things have broken

    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

  • September 1, 2017 at 12:06 pm

    #1957885

    These type of error is usually related to the IO/Hardware issues and it may occur due to sudden computer shutdown/crash or a forced shutdown of the machine that for some reason corrupted the files
    1.Ensure you have a valid backup; hopefully it will be from prior to the corruption, but not so long ago that the data isn't useful. You should set this aside in case direct repair isn't possible and you need to recover data from the backup.
    2. Try it SQL Server Repair Toolbox. Alternative solution.

Viewing 3 posts - 1 through 2 (of 2 total)

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