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.

我跑了

dbcc checkdb

哪个告诉我应该用选项REPAIR_ALLOW_DATA_LOSS恢复,所以我最终跑了

DBCC CHECKDB (my_db_name,REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS

但这导致大约2 000行丢失.我恢复了备份,但现在我担心这会再次发生,因为我们已经在2周前在同一个数据库中遇到了一致性问题,但后来发生在索引中(重新创建的索引解决了问题).

我们调查了光盘 – RAID5看起来不错,没有错误,也没有任何光盘检查实用程序发现任何硬件问题.

这可能是由操作系统(Windows Server 2003)或MSsql(MSsql Server 2005)引起的吗？