during read in file ' D:\data\BooksDB.mdf ', where the offset is 0x0000011d10400, the operating system has returned error 1117 to SQL Server (this item cannot be run due to an I/O device error Requests)the SQL Server error log and other messages in the System event log may provide more detailed information. This is a serious system-level error condition that threatens database integrity and must be corrected immediately. Please perform a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; For more information, see SQL Server Books Online.
Results of DBCC CHECKDB:
Msg 8966, Level 16, State 2, line 1th
The latch type SH cannot be used to read and latch the page (1:583,810). 1117 (this request cannot be run due to an I/O device error.) Failed
Msg 8978, Level 16, State 1, line 1th
Table error: Object ID 1690489101, index ID 22, partition ID 72057594089570304, allocation unit ID 72057594094288896 (type in-row data). Page (1:470,146) a reference to it is missing from the previous page (1:583,810). This may be due to a problem with the chain link.
MSG 2533, Level 16, State 1, line 1th
Table error: Cannot see page assigned to Object ID 1690489101, index ID 22, partition ID 72057594089570304, allocation unit ID 72057594094288896 (type In-row data) (1:583,810). The page may not be valid, or the page header may contain an incorrect allocation unit ID.
Msg 8976, Level 16, State 1, line 1th
Table error: Object ID 1690489101, index ID 22, partition ID 72057594089570304, allocation unit ID 72057594094288896 (type in-row data). The page (1:583,810) was not found during the scan, but the page's parent (1:70,834) and Previous (1:685,949) references it. Please check the previous error message.
There are 66867 rows in the 1089 page of the object ' T_in_top '.
CHECKDB found 0 allocation errors and 3 conformance errors in table ' T_in_top ' (Object ID 1690489101).
Ask the great God for help!
Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.
Help with SQL Server I/o device Error!!!