How to fix SQL Server detected a logical consistency-based I/O errors?
Posted on 2012-03-23
After running this command and seeing this error in the systems logs and SQL Server logs, I see this error.
DBCC CHECKDB (wss_pbc_content_hermes) WITH ALL_ERRORMSGS, NO_INFOMSGS
Msg 824, Level 24, State 2, Line 1
SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:57481; actual 0:0). It occurred during a read of page (1:57481) in database ID 26 at offset 0x0000001c112000 in file 'D:\SP_Databases\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\wss_pbc_content_hermes.mdf:MSSQL_DBCC26'. 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.
Is there any hope to repair this type of error? What can I do?