MSSQL error: consistency-based I/O error - can it be caused by an MSSQL or OS problem?

Posted by Philipp Keller on Server Fault See other posts from Server Fault or by Philipp Keller
Published on 2010-06-02T06:57:57Z Indexed on 2010/06/02 7:04 UTC
Read the original article Hit count: 325

Filed under:
|

This is what I saw in the windows error log:

SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x19fedd20; actual: 0x19fed5e3). It occurred during a read of page (1:1764) in database ID 6 at offset 0x00000000dc8000 in file 'D:\mssql\local_repository_pbdiffimport.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.

I ran

dbcc checkdb

which told me I should restore with option REPAIR_ALLOW_DATA_LOSS, so I eventually ran

DBCC CHECKDB (my_db_name, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS

But that resulted in about 2'000 rows being lost. I restored a backup but now I'm afraid this will happen again since we already had a consistency problem in the same database about 2 weeks ago but then it happened in an index (recreated indexes solved the problem).

We have investigated the discs - RAID5 looks good, no errors, and also none of the disc-check-utilities have revealed any hardware problem.

Can this be caused by OS (Windows Server 2003) or by MSSQL (MSSQL Server 2005)?

© Server Fault or respective owner

Related posts about sql-server

Related posts about sql-server-2005