Toad World® Forums

SQL Server 2008 R2

I am using SQL Server 2008 R2.

Everything was running fine until it recently stopped running for no real apparent reason. The error message occurs: Sql Server Detected A Logical Consistency-Based I/O Error: Incorrect Checksum. (Microsoft SQL Server, Error:824) Please how do i correct this error.

Regards.

The error 824 is ususally related to the IO/Hardware issues. run the DBCC Checkdb on the database to ensure no corruption exist. Use <database_name> go dbcc checkdb with data_purity go . If the database is really large us the dbcc checktable.

Also you can read info here: http://www.mssqlserver.repair/