Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Regular Coder
    Join Date
    Sep 2006
    Location
    India Mumbai
    Posts
    248
    Thanks
    13
    Thanked 1 Time in 1 Post

    Checksum error after restoring MSSQL 2005 DB

    Hi all,
    I am trying to restore a .bkp file. it gets restored sucessfully. but when i open any table i get the error as below:
    Error Source : .Net SqlClient Data Provider
    Error Message: SQL Server detected a logical consistency-based I/O error: incorrect checksum.....ect etc

    Can i get some help on it. Why is it show

    Thanks

  • #2
    New to the CF scene
    Join Date
    Feb 2011
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Checksum error after restoring MSSQL 2005 DB

    Hey,
    The reason you are getting this error is because of your database which has encountered logical inconsistency problem. This logical inconsistency is reported through Error 824 and thus is called checksum error. This inconsistency can also lead to the other issues like Bad Page Id, Short Transfer, Stale Read, Audit failure and so on.

    This consistency is possibly caused due to out of order or faulty I/O device or due to incomplete write of database page due to power loss. In this situation the checksum function can lead hectic database corruption which is very hard to fix. So, in order to resolve the issue use the backup of the database that you have or go for any third party SQL repair software.

    All the best!


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •