Checksum error after restoring MSSQL 2005 DB

[bhakti_thakkar]

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

[nancyjohnson878]

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 (http://www.mssqldatabaserepair.org) software.

All the best!