DBCC CheckDB檢查SQL Server數據庫,出現如下錯誤:
DBCC results for 'AIS20210XXXX'.
消息 8939,級別 16,狀態 98,第 1 行
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -1880844493790052352 (type Unknown), page (58853:-437918235). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -14.
消息 8939,級別 16,狀態 98,第 1 行
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -1880844493790052352 (type Unknown), page (58853:-437918235). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -1.
消息 8939,級別 16,狀態 98,第 1 行
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -1880844493790052352 (type Unknown), page (58853:-437918235). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -1.
消息 8939,級別 16,狀態 98,第 1 行
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -1880844493790052352 (type Unknown), page (58853:-437918235). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -1.
消息 8939,級別 16,狀態 98,第 1 行
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -1880844493790052352 (type Unknown), page (58853:-437918235). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -1.
消息 8939,級別 16,狀態 98,第 1 行
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -1880844493790052352 (type Unknown), page (58853:-437918235). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -1.
消息 8939,級別 16,狀態 98,第 1 行
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -1880844493790052352 (type Unknown), page (58853:-437918235). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -1.
消息 8939,級別 16,狀態 98,第 1 行
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -1880844493790052352 (type Unknown), page (58853:-437918235). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -1.
消息 8939,級別 16,狀態 98,第 1 行
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -1880844493790052352 (type Unknown), page (58853:-437918235). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -1.
消息 8939,級別 16,狀態 98,第 1 行
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -1880844493790052352 (type Unknown), page (58853:-437918235). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -1.
Service Broker Msg 9675, State 1: Message Types analyzed: 14.
Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.
Service Broker Msg 9667, State 1: Services analyzed: 3.
Service Broker Msg 9668, State 1: Service Queues analyzed: 3.
Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.
Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.
Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.
Service Broker Msg 9605, State 1: Conversation Priorities analyzed: 0.
CHECKDB found 0 allocation errors and 10 consistency errors not associated with any single object.
DBCC results for 'sys.sysrscols'.
DBCC results for 'sys.sysexttables'.
There are 0 rows in 0 pages for object "sys.sysexttables".
消息 8978,級別 16,狀態 1,第 1 行
Table error: Object ID 41, index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (type In-row data). Page (1:93751) is missing a reference from previous page (1:370770). Possible chain linkage problem.
消息 8928,級別 16,狀態 1,第 1 行
Object ID 41, index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (type In-row data): Page (1:370770) could not be processed. See other errors for details.
消息 8976,級別 16,狀態 1,第 1 行
Table error: Object ID 41, index ID 1, partition ID 281474979397632, alloc unit ID 281474979397632 (type In-row data). Page (1:370770) was not seen in the scan although its parent (1:453776) and previous (1:346431) refer to it. Check any previous errors.
DBCC results for 'sys.syscolpars'.
There are 114601 rows in 8209 pages for object "sys.syscolpars".
CHECKDB found 0 allocation errors and 3 consistency errors in table 'sys.syscolpars' (object ID 41).
DBCC results for 'sys.sysxlgns'.
DBCC results for 'CMK_t_HorzScreenTabEntry'.
There are 0 rows in 0 pages for object "CMK_t_HorzScreenTabEntry".
消息 8978,級別 16,狀態 1,第 1 行
Table error: Object ID 137923713, index ID 3, partition ID 72057594845921280, alloc unit ID 72057594785890304 (type In-row data). Page (1:1290856) is missing a reference from previous page (1:1290857). Possible chain linkage problem.
消息 8928,級別 16,狀態 1,第 1 行
Object ID 137923713, index ID 3, partition ID 72057594845921280, alloc unit ID 72057594785890304 (type In-row data): Page (1:1290857) could not be processed. See other errors for details.
消息 8976,級別 16,狀態 1,第 1 行
Table error: Object ID 137923713, index ID 3, partition ID 72057594845921280, alloc unit ID 72057594785890304 (type In-row data). Page (1:1290857) was not seen in the scan although its parent (1:1429268) and previous (1:694320) refer to it. Check any previous errors.
DBCC results for 'T_SUB_PICKMTRLDATA_LK'.
There are 127445 rows in 2817 pages for object "T_SUB_PICKMTRLDATA_LK".
CHECKDB found 0 allocation errors and 3 consistency errors in table 'T_SUB_PICKMTRLDATA_LK' (object ID 137923713).
DBCC results for 'V_HS_OUTACCTG_VH'.
There are 3089 rows in 128 pages for object "T_PLM_CFG_AUTH_INFOR".
消息 8976,級別 16,狀態 1,第 1 行
Table error: Object ID 621401433, index ID 1, partition ID 72057594838188032, alloc unit ID 72057594779205632 (type In-row data). Page (1:1290853) was not seen in the scan although its parent (1:739359) and previous (1:1290852) refer to it. Check any previous errors.
消息 8978,級別 16,狀態 1,第 1 行
Table error: Object ID 621401433, index ID 1, partition ID 72057594838188032, alloc unit ID 72057594779205632 (type In-row data). Page (1:1290854) is missing a reference from previous page (1:1290853). Possible chain linkage problem.
消息 8928,級別 16,狀態 1,第 1 行
Object ID 621401433, index ID 1, partition ID 72057594838188032, alloc unit ID 72057594779205632 (type In-row data): Page (1:1290853) could not be processed. See other errors for details.
DBCC results for 'T_SUB_PICKMTRLDATA'.
There are 127430 rows in 8526 pages for object "T_SUB_PICKMTRLDATA".
CHECKDB found 0 allocation errors and 3 consistency errors in table 'T_SUB_PICKMTRLDATA' (object ID 621401433).
There are 0 rows in 0 pages for object "T_PRD_MASTKSCOPE".
消息 8928,級別 16,狀態 1,第 1 行
Object ID 1411445713, index ID 0, partition ID 72057641066364928, alloc unit ID 72057643179180032 (type In-row data): Page (1:110483) could not be processed. See other errors for details.
消息 8928,級別 16,狀態 1,第 1 行
Object ID 1411445713, index ID 0, partition ID 72057641066364928, alloc unit ID 72057643179180032 (type In-row data): Page (1:110487) could not be processed. See other errors for details.
消息 8928,級別 16,狀態 1,第 1 行
Object ID 1411445713, index ID 0, partition ID 72057641066364928, alloc unit ID 72057643179180032 (type In-row data): Page (1:97727) could not be processed. See other errors for details.
消息 8928,級別 16,狀態 1,第 1 行
Object ID 1411445713, index ID 0, partition ID 72057641066364928, alloc unit ID 72057643179180032 (type In-row data): Page (1:97946) could not be processed. See other errors for details.
消息 8928,級別 16,狀態 1,第 1 行
Object ID 1411445713, index ID 0, partition ID 72057641066364928, alloc unit ID 72057643179180032 (type In-row data): Page (1:97950) could not be processed. See other errors for details.
消息 8939,級別 16,狀態 98,第 1 行
Table error: Object ID 1411445713, index ID 0, partition ID 72057641066364928, alloc unit ID 72057643179180032 (type In-row data), page (1:1104861). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.
消息 8928,級別 16,狀態 1,第 1 行
Object ID 1411445713, index ID 0, partition ID 72057641066364928, alloc unit ID 72057643179180032 (type In-row data): Page (1:1104861) could not be processed. See other errors for details.
消息 8939,級別 16,狀態 98,第 1 行
Table error: Object ID 1411445713, index ID 0, partition ID 72057641066364928, alloc unit ID 72057643179180032 (type In-row data), page (1:1104869). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.
消息 8928,級別 16,狀態 1,第 1 行
Object ID 1411445713, index ID 0, partition ID 72057641066364928, alloc unit ID 72057643179180032 (type In-row data): Page (1:1104869) could not be processed. See other errors for details.
DBCC results for 'TINVAGE263430BD'.
There are 167702 rows in 6537 pages for object "TINVAGE263430BD".
There are 33 rows in 1 pages for object "T_HS_SPLITTABLE".
消息 8976,級別 16,狀態 1,第 1 行
Table error: Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data). Page (1:177668) was not seen in the scan although its parent (1:170529) and previous (1:177667) refer to it. Check any previous errors.
消息 8978,級別 16,狀態 1,第 1 行
Table error: Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data). Page (1:177669) is missing a reference from previous page (1:177668). Possible chain linkage problem.
消息 8978,級別 16,狀態 1,第 1 行
Table error: Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data). Page (1:486803) is missing a reference from previous page (1:988359). Possible chain linkage problem.
消息 8939,級別 16,狀態 98,第 1 行
Table error: Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data), page (1:177668). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.
消息 8978,級別 16,狀態 1,第 1 行
Table error: Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data). Page (1:507077) is missing a reference from previous page (1:988363). Possible chain linkage problem.
消息 8928,級別 16,狀態 1,第 1 行
Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data): Page (1:177668) could not be processed. See other errors for details.
消息 8978,級別 16,狀態 1,第 1 行
Table error: Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data). Page (1:171225) is missing a reference from previous page (1:988367). Possible chain linkage problem.
消息 8976,級別 16,狀態 1,第 1 行
Table error: Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data). Page (1:505728) was not seen in the scan although its parent (1:170529) and previous (1:166862) refer to it. Check any previous errors.
消息 8928,級別 16,狀態 1,第 1 行
Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data): Page (1:505728) could not be processed. See other errors for details.
消息 8928,級別 16,狀態 1,第 1 行
Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data): Page (1:505732) could not be processed. See other errors for details.
消息 8978,級別 16,狀態 1,第 1 行
Table error: Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data). Page (1:488068) is missing a reference from previous page (1:988371). Possible chain linkage problem.
消息 8976,級別 16,狀態 1,第 1 行
Table error: Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data). Page (1:505732) was not seen in the scan although its parent (1:170529) and previous (1:486807) refer to it. Check any previous errors.
消息 8978,級別 16,狀態 1,第 1 行
Table error: Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data). Page (1:988432) is missing a reference from previous page (1:505732). Possible chain linkage problem.
消息 8976,級別 16,狀態 1,第 1 行
Table error: Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data). Page (1:988363) was not seen in the scan although its parent (1:170529) and previous (1:507076) refer to it. Check any previous errors.
消息 8978,級別 16,狀態 1,第 1 行
Table error: Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data). Page (1:988377) is missing a reference from previous page (1:505728). Possible chain linkage problem.
消息 8976,級別 16,狀態 1,第 1 行
Table error: Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data). Page (1:988371) was not seen in the scan although its parent (1:170529) and previous (1:488067) refer to it. Check any previous errors.
消息 8976,級別 16,狀態 1,第 1 行
Table error: Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data). Page (1:988367) was not seen in the scan although its parent (1:170529) and previous (1:171224) refer to it. Check any previous errors.
消息 8939,級別 16,狀態 98,第 1 行
Table error: Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data), page (1:988359). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.
消息 8928,級別 16,狀態 1,第 1 行
Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data): Page (1:988359) could not be processed. See other errors for details.
消息 8939,級別 16,狀態 98,第 1 行
Table error: Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data), page (1:988363). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.
消息 8928,級別 16,狀態 1,第 1 行
Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data): Page (1:988363) could not be processed. See other errors for details.
消息 8939,級別 16,狀態 98,第 1 行
Table error: Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data), page (1:988367). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.
消息 8928,級別 16,狀態 1,第 1 行
Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data): Page (1:988367) could not be processed. See other errors for details.
消息 8939,級別 16,狀態 98,第 1 行
Table error: Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data), page (1:988371). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.
消息 8928,級別 16,狀態 1,第 1 行
Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data): Page (1:988371) could not be processed. See other errors for details.
消息 8976,級別 16,狀態 1,第 1 行
Table error: Object ID 1443445827, index ID 1, partition ID 72057641066823680, alloc unit ID 72057643179638784 (type In-row data). Page (1:988359) was not seen in the scan although its parent (1:170529) and previous (1:486802) refer to it. Check any previous errors.
DBCC results for 'TINVAGEBAL263430'.
There are 11122 rows in 349 pages for object "TINVAGEBAL263430".
CHECKDB found 0 allocation errors and 26 consistency errors in table 'TINVAGEBAL263430' (object ID 1443445827).
DBCC results for 'T_BD_MATERIALSALE'.
Table error: Object ID 1764266136, index ID 1, partition ID 72057595120582656, alloc unit ID 72057595037417472 (type LOB data), page (1:813834). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.
消息 8928,級別 16,狀態 1,第 1 行
Object ID 1764266136, index ID 1, partition ID 72057595120582656, alloc unit ID 72057595037417472 (type LOB data): Page (1:813834) could not be processed. See other errors for details.
消息 8965,級別 16,狀態 1,第 1 行
Table error: Object ID 1764266136, index ID 1, partition ID 72057595120582656, alloc unit ID 72057595037417472 (type LOB data). The off-row data node at page (1:813834), slot 0, text ID 3500345393152 is referenced by page (1:813192), slot 19, but was not seen in the scan.
消息 8965,級別 16,狀態 1,第 1 行
Table error: Object ID 1764266136, index ID 1, partition ID 72057595120582656, alloc unit ID 72057595037417472 (type LOB data). The off-row data node at page (1:813834), slot 1, text ID 3504258547712 is referenced by page (1:813833), slot 4, but was not seen in the scan.
消息 8929,級別 16,狀態 1,第 1 行
Object ID 1764266136, index ID 1, partition ID 72057595120582656, alloc unit ID 72057595048558592 (type In-row data): Errors found in off-row data with ID 3500345393152 owned by data record identified by RID = (1:946197:63)
消息 8929,級別 16,狀態 1,第 1 行
Object ID 1764266136, index ID 1, partition ID 72057595120582656, alloc unit ID 72057595048558592 (type In-row data): Errors found in off-row data with ID 3504258547712 owned by data record identified by RID = (1:946197:87)
DBCC results for 'T_BF_ARCHIVEFILES'.
There are 6882 rows in 50 pages for object "T_BF_ARCHIVEFILES".
CHECKDB found 0 allocation errors and 6 consistency errors in table 'T_BF_ARCHIVEFILES' (object ID 1764266136).
DBCC results for 'T_SUB_PTBILLTYPE'.
There are 0 rows in 0 pages for object "T_SUB_PTBILLTYPE".
消息 8939,級別 16,狀態 98,第 1 行
Table error: Object ID 1968166207, index ID 4, partition ID 72057595274395648, alloc unit ID 72057595199946752 (type In-row data), page (1:381467). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.
消息 8928,級別 16,狀態 1,第 1 行
Object ID 1968166207, index ID 4, partition ID 72057595274395648, alloc unit ID 72057595199946752 (type In-row data): Page (1:381467) could not be processed. See other errors for details.
消息 8976,級別 16,狀態 1,第 1 行
Table error: Object ID 1968166207, index ID 4, partition ID 72057595274395648, alloc unit ID 72057595199946752 (type In-row data). Page (1:381467) was not seen in the scan although its parent (1:589083) and previous (1:703772) refer to it. Check any previous errors.
消息 8976,級別 16,狀態 1,第 1 行
Table error: Object ID 1968166207, index ID 1, partition ID 72057595274330112, alloc unit ID 72057595199881216 (type In-row data). Page (1:703797) was not seen in the scan although its parent (1:449579) and previous (1:703796) refer to it. Check any previous errors.
消息 8978,級別 16,狀態 1,第 1 行
Table error: Object ID 1968166207, index ID 4, partition ID 72057595274395648, alloc unit ID 72057595199946752 (type In-row data). Page (1:713968) is missing a reference from previous page (1:381467). Possible chain linkage problem.
消息 8939,級別 16,狀態 98,第 1 行
Table error: Object ID 1968166207, index ID 1, partition ID 72057595274330112, alloc unit ID 72057595199881216 (type In-row data), page (1:703797). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.
消息 8928,級別 16,狀態 1,第 1 行
Object ID 1968166207, index ID 1, partition ID 72057595274330112, alloc unit ID 72057595199881216 (type In-row data): Page (1:703797) could not be processed. See other errors for details.
消息 8978,級別 16,狀態 1,第 1 行
Table error: Object ID 1968166207, index ID 1, partition ID 72057595274330112, alloc unit ID 72057595199881216 (type In-row data). Page (1:703798) is missing a reference from previous page (1:703797). Possible chain linkage problem.
DBCC results for 'T_STK_INVENTORYLOG'.
There are 548669 rows in 20079 pages for object "T_STK_INVENTORYLOG".
CHECKDB found 0 allocation errors and 8 consistency errors in table 'T_STK_INVENTORYLOG' (object ID 1968166207).
DBCC results for 'T_ER_REASONSREQUESTENTRY'.
There are 0 rows in 0 pages for object "CMK_LS_EventMarketRecord".
CHECKDB found 0 allocation errors and 68 consistency errors in database 'AIS202106251445741'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (AIS202106251443652).
消息 824,級別 24,狀態 2,第 1 行
SQL Server detected a logical consistency-based I/O error: unable to decrypt page due to missing DEK. It occurred during a read of page (1:370770) in database ID 10 at offset 0x000000b50a4000 in file 'E:\20230404\2023.04.04-bad-dbOK\AIS202106253652_Data.mdf_MSSQL_DBCC10'. 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.
消息 824,級別 24,狀態 2,第 1 行
SQL Server detected a logical consistency-based I/O error: unable to decrypt page due to missing DEK. It occurred during a read of page (1:370770) in database ID 10 at offset 0x000000b50a4000 in file 'E:\20230404\2023.04.04-bad-dbOK\AIS20210625144134_Data.mdf_MSSQL_DBCC10'. 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.
消息 824,級別 24,狀態 2,第 1 行
SQL Server detected a logical consistency-based I/O error: unable to decrypt page due to missing DEK. It occurred during a read of page (1:370770) in database ID 10 at offset 0x000000b50a4000 in file 'E:\20230404\2023.04.04-bad-dbOK\AIS20210625144134_Data.mdf_MSSQL_DBCC10'. 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.
消息 824,級別 24,狀態 2,第 1 行
SQL Server detected a logical consistency-based I/O error: unable to decrypt page due to missing DEK. It occurred during a read of page (1:370770) in database ID 10 at offset 0x000000b50a4000 in file 'E:\20230404\2023.04.04-bad-dbOK\AIS20210625144134_Data.mdf_MSSQL_DBCC10'. 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.
消息 824,級別 24,狀態 2,第 1 行
SQL Server detected a logical consistency-based I/O error: unable to decrypt page due to missing DEK. It occurred during a read of page (1:370770) in database ID 10 at offset 0x000000b50a4000 in file 'E:\20230404\2023.04.04-bad-dbOK\AIS20210625144134_Data.mdf_MSSQL_DBCC10'. 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.
消息 824,級別 24,狀態 2,第 1 行
SQL Server detected a logical consistency-based I/O error: unable to decrypt page due to missing DEK. It occurred during a read of page (1:370770) in database ID 10 at offset 0x000000b50a4000 in file 'E:\20230404\2023.04.04-bad-dbOK\AIS20210625144134_Data.mdf_MSSQL_DBCC10'. 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.
執行Transact-SQL 語句或批處理時發生了異常。(Microsoft.SQLServer,Connectionlnfo)
SQL Server 檢測到基于一致性的邏輯 I/O 錯誤 由于缺少 DEK,無法解密頁。
在文件F:\20230404\A1S202106251XXXXX_Data,mdf' 中偏移量為 0x000000650a4000 的位置
對數據庫ID7 中的頁(1:370770) 執行 讀取 期間,發生了該錯誤。
SQL Server 錯誤日志或系統事件日志中的其他消息可能提供了更詳細信息。
這是一個威助數據庫完整性的嚴重錯誤條件,必須立即糾正。
請執行完整的數據庫一致性檢查(DBCC CHECKDB)。此錯誤可以許多因素導致 ;
有關詳細信息,請參閱 SQL Server聯機以書。(Microsof SQL Server,錯誤: 824)
數據庫完美修復,附加到SQL,軟件正常使用。
建議:
1、重要數據要經常備份,【異地備份重要數據,一天一次】。備份方案推薦:秒備份。
2、建議將重要數據定時備份到遠程FTP,可以確保數據安全。
SQL Oracle MySQL數據庫可以做恢復修復,QQ : 80554803,TEL : 18620906802 (微信)
SQL and Oracle and MySQL database can be restored and repaired, wechat: 18620906802, Skype: jogewang, Email:Data700@qq.com
甲骨文Oracle,微軟SQLServer,MySQL常見錯誤修復恢復。底層修復。技術支持。