Help with SQL Server I/o device Error!!!

Source: Internet
Author: User
Tags sql server books server error log

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!!!

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.