27,579
社区成员
发帖
与我相关
我的任务
分享DBCC CHECKDB报错，该如何处理？
SQL Server双机环境，磁盘柜(RAID5)的一块硬盘坏了，导致服务停止，换了一块硬盘，重器服务器，服务可以启动。但用DBCC CHECKDB检查时报错：
服务器: 消息 8966，级别 16，状态 2，行 1
Could not read and latch page (4:1460240) with latch type UP. 1117(error not found) failed.
服务器: 消息 8966，级别 16，状态 1，行 1
Could not read and latch page (4:1460241) with latch type UP. 1117(error not found) failed.
服务器: 消息 8966，级别 16，状态 1，行 1
Could not read and latch page (4:1460242) with latch type UP. 1117(error not found) failed.
服务器: 消息 8966，级别 16，状态 1，行 1
Could not read and latch page (4:1460243) with latch type UP. 1117(error not found) failed.
服务器: 消息 8966，级别 16，状态 1，行 1
Could not read and latch page (4:1460244) with latch type UP. 1117(error not found) failed.
服务器: 消息 8966，级别 16，状态 1，行 1
Could not read and latch page (4:1460245) with latch type UP. 1117(error not found) failed.
服务器: 消息 8966，级别 16，状态 1，行 1
Could not read and latch page (4:1460246) with latch type UP. 1117(error not found) failed.
服务器: 消息 8966，级别 16，状态 1，行 1
Could not read and latch page (4:1460247) with latch type UP. 1117(error not found) failed.
..........
..........
服务器: 消息 2533，级别 16，状态 1，行 1
Table error: Page (4:1460240) allocated to object ID 2098106515, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
服务器: 消息 2533，级别 16，状态 1，行 1
Table error: Page (4:1460241) allocated to object ID 2098106515, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
服务器: 消息 2533，级别 16，状态 1，行 1
Table error: Page (4:1460242) allocated to object ID 2098106515, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
服务器: 消息 2533，级别 16，状态 1，行 1
Table error: Page (4:1460243) allocated to object ID 2098106515, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
服务器: 消息 2533，级别 16，状态 1，行 1
Table error: Page (4:1460244) allocated to object ID 2098106515, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
服务器: 消息 2533，级别 16，状态 1，行 1
Table error: Page (4:1460245) allocated to object ID 2098106515, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
服务器: 消息 2533，级别 16，状态 1，行 1
Table error: Page (4:1460246) allocated to object ID 2098106515, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
服务器: 消息 2533，级别 16，状态 1，行 1
Table error: Page (4:1460247) allocated to object ID 2098106515, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
服务器: 消息 8976，级别 16，状态 1，行 1
Table error: Object ID 2098106515, index ID 1. Page (4:1460240) was not seen in the scan although its parent (4:1459363) and previous (4:1460239) refer to it. Check any previous errors.
服务器: 消息 8980，级别 16，状态 1，行 1
Table error: Object ID 2098106515, index ID 1. Index node page (4:1459363), slot 46 refers to child page (4:1460241) and previous child (4:1460240), but they were not encountered.
服务器: 消息 8980，级别 16，状态 1，行 1
Table error: Object ID 2098106515, index ID 1. Index node page (4:1459363), slot 47 refers to child page (4:1460242) and previous child (4:1460241), but they were not encountered.
服务器: 消息 8980，级别 16，状态 1，行 1
Table error: Object ID 2098106515, index ID 1. Index node page (4:1459363), slot 48 refers to child page (4:1460243) and previous child (4:1460242), but they were not encountered.
服务器: 消息 8980，级别 16，状态 1，行 1
Table error: Object ID 2098106515, index ID 1. Index node page (4:1459363), slot 49 refers to child page (4:1460244) and previous child (4:1460243), but they were not encountered.
服务器: 消息 8980，级别 16，状态 1，行 1
Table error: Object ID 2098106515, index ID 1. Index node page (4:1459363), slot 50 refers to child page (4:1460245) and previous child (4:1460244), but they were not encountered.
服务器: 消息 8980，级别 16，状态 1，行 1
Table error: Object ID 2098106515, index ID 1. Index node page (4:1459363), slot 51 refers to child page (4:1460246) and previous child (4:1460245), but they were not encountered.
服务器: 消息 8976，级别 16，状态 1，行 1
Table error: Object ID 2098106515, index ID 1. Page (4:1460247) was not seen in the scan although its parent (4:1459363) and previous (4:1504418) refer to it. Check any previous errors.
服务器: 消息 8978，级别 16，状态 1，行 1
Table error: Object ID 2098106515, index ID 1. Page (4:1461272) is missing a reference from previous page (4:1460247). Possible chain linkage problem.
服务器: 消息 8978，级别 16，状态 1，行 1
Table error: Object ID 2098106515, index ID 1. Page (4:1504418) is missing a reference from previous page (4:1460246). Possible chain linkage problem.
..........
加上REPAIR_REBUILD也无法修复，请问这种情况该怎么办？
服务器: 消息 8966，级别 16，状态 2，行 1
Could not read and latch page (4:1460240) with latch type UP. 1117(error not found) failed.
服务器: 消息 8966，级别 16，状态 1，行 1
Could not read and latch page (4:1460241) with latch type UP. 1117(error not found) failed.
服务器: 消息 8966，级别 16，状态 1，行 1
Could not read and latch page (4:1460242) with latch type UP. 1117(error not found) failed.
服务器: 消息 8966，级别 16，状态 1，行 1
Could not read and latch page (4:1460243) with latch type UP. 1117(error not found) failed.
服务器: 消息 8966，级别 16，状态 1，行 1
Could not read and latch page (4:1460244) with latch type UP. 1117(error not found) failed.
服务器: 消息 8966，级别 16，状态 1，行 1
Could not read and latch page (4:1460245) with latch type UP. 1117(error not found) failed.
服务器: 消息 8966，级别 16，状态 1，行 1
Could not read and latch page (4:1460246) with latch type UP. 1117(error not found) failed.
服务器: 消息 8966，级别 16，状态 1，行 1
Could not read and latch page (4:1460247) with latch type UP. 1117(error not found) failed.
..........
..........
服务器: 消息 2533，级别 16，状态 1，行 1
Table error: Page (4:1460240) allocated to object ID 2098106515, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
服务器: 消息 2533，级别 16，状态 1，行 1
Table error: Page (4:1460241) allocated to object ID 2098106515, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
服务器: 消息 2533，级别 16，状态 1，行 1
Table error: Page (4:1460242) allocated to object ID 2098106515, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
服务器: 消息 2533，级别 16，状态 1，行 1
Table error: Page (4:1460243) allocated to object ID 2098106515, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
服务器: 消息 2533，级别 16，状态 1，行 1
Table error: Page (4:1460244) allocated to object ID 2098106515, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
服务器: 消息 2533，级别 16，状态 1，行 1
Table error: Page (4:1460245) allocated to object ID 2098106515, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
服务器: 消息 2533，级别 16，状态 1，行 1
Table error: Page (4:1460246) allocated to object ID 2098106515, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
服务器: 消息 2533，级别 16，状态 1，行 1
Table error: Page (4:1460247) allocated to object ID 2098106515, index ID 0 was not seen. Page may be invalid or have incorrect object ID information in its header.
服务器: 消息 8976，级别 16，状态 1，行 1
Table error: Object ID 2098106515, index ID 1. Page (4:1460240) was not seen in the scan although its parent (4:1459363) and previous (4:1460239) refer to it. Check any previous errors.
服务器: 消息 8980，级别 16，状态 1，行 1
Table error: Object ID 2098106515, index ID 1. Index node page (4:1459363), slot 46 refers to child page (4:1460241) and previous child (4:1460240), but they were not encountered.
服务器: 消息 8980，级别 16，状态 1，行 1
Table error: Object ID 2098106515, index ID 1. Index node page (4:1459363), slot 47 refers to child page (4:1460242) and previous child (4:1460241), but they were not encountered.
服务器: 消息 8980，级别 16，状态 1，行 1
Table error: Object ID 2098106515, index ID 1. Index node page (4:1459363), slot 48 refers to child page (4:1460243) and previous child (4:1460242), but they were not encountered.
服务器: 消息 8980，级别 16，状态 1，行 1
Table error: Object ID 2098106515, index ID 1. Index node page (4:1459363), slot 49 refers to child page (4:1460244) and previous child (4:1460243), but they were not encountered.
服务器: 消息 8980，级别 16，状态 1，行 1
Table error: Object ID 2098106515, index ID 1. Index node page (4:1459363), slot 50 refers to child page (4:1460245) and previous child (4:1460244), but they were not encountered.
服务器: 消息 8980，级别 16，状态 1，行 1
Table error: Object ID 2098106515, index ID 1. Index node page (4:1459363), slot 51 refers to child page (4:1460246) and previous child (4:1460245), but they were not encountered.
服务器: 消息 8976，级别 16，状态 1，行 1
Table error: Object ID 2098106515, index ID 1. Page (4:1460247) was not seen in the scan although its parent (4:1459363) and previous (4:1504418) refer to it. Check any previous errors.
服务器: 消息 8978，级别 16，状态 1，行 1
Table error: Object ID 2098106515, index ID 1. Page (4:1461272) is missing a reference from previous page (4:1460247). Possible chain linkage problem.
服务器: 消息 8978，级别 16，状态 1，行 1
Table error: Object ID 2098106515, index ID 1. Page (4:1504418) is missing a reference from previous page (4:1460246). Possible chain linkage problem.
..........
加上REPAIR_REBUILD也无法修复，请问这种情况该怎么办？
...全文
请发表友善的回复…
发表回复
