Home > database >  Wrong used to query, repair, logical I/O error, can not use the latch type, the DROP table delete to
Wrong used to query, repair, logical I/O error, can not use the latch type, the DROP table delete to

Time:10-11

SQL14
When querying data detected based on the consistency of logic I/O error protection option is invalid, let me for consistency check
Repair
Refer to https://blog.csdn.net/szstephenzhou/article/details/39670309
, prompt can't use the latch type SH read and latch page




Overall repair repair a single table not to fix, also not line, consistency check error, also cried,
Shrinkage during the next database,


Consistency check will appear the following error
Table error: object ID 146099561, index ID 1, partition ID 72057594043498496, allocation unit ID 72057594046316544 (type - row In the data), page not found In the process of scanning (5735) sons, but the parent of the page (9848) stands and back (400) was cited it, please check the error messages before,


Are carried out under a single user
In the process of debugging and some puzzling errors