DBCC CheckDB检测错误如下:
消息 605,级别 12,状态 3,第 1 行
Attempt to fetch logical page (1:415656) in database 7 failed. It belongs to allocation unit 2314885530818445312 not to 281474980642816.
消息 605,级别 12,状态 3,第 1 行
Attempt to fetch logical page (1:415656) in database 7 failed. It belongs to allocation unit 2314885530818445312 not to 281474980642816.
DBCC results for 'ERP_DATA'.
消息 8939,级别 16,状态 98,第 1 行
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 2387225703656521728 (type Unknown), page (1:413520). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -1.
消息 8909,级别 16,状态 1,第 1 行
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 9007336695791616 (type Unknown), page ID (1:413521) contains an incorrect page ID in its page header. The PageId in the page header = (97:6488096).
消息 8909,级别 16,状态 1,第 1 行
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 9007336695791616 (type Unknown), page ID (1:413522) contains an incorrect page ID in its page header. The PageId in the page header = (111:6422560).
消息 8909,级别 16,状态 1,第 1 行
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 29555009995669504 (type Unknown), page ID (1:413523) contains an incorrect page ID in its page header. The PageId in the page header = (32:2097184).
消息 8939,级别 16,状态 98,第 1 行
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 2814887208157184 (type Unknown), page (47:3080224). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.
消息 8939,级别 16,状态 98,第 1 行
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 3286783303050330112 (type Unknown), page (8481:555810816). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -1.
消息 8909,级别 16,状态 1,第 1 行
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 28147897109905408 (type Unknown), page ID (1:413526) contains an incorrect page ID in its page header. The PageId in the page header = (116:7602273).
消息 8909,级别 16,状态 1,第 1 行
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 9007693182402560 (type Unknown), page ID (1:413527) contains an incorrect page ID in its page header. The PageId in the page header = (73:7602277).
消息 8939,级别 16,状态 5,第 1 行
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 2314885530818445312 (type Unknown), page (1:415656). Test (m_headerVersion == HEADER_7_0) failed. Values are 32 and 1.
消息 8939,级别 16,状态 8,第 1 行
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 2314885530818445312 (type Unknown), page (1:415656). Test (m_freeCnt <= PAGESIZE - PageHeaderOverhead ()) failed. Values are 8224 and 8096.
消息 8939,级别 16,状态 10,第 1 行
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 2314885530818445312 (type Unknown), page (1:415656). Test (m_slotCnt < MaxSlot) failed. Values are 8224 and 4048.
消息 8939,级别 16,状态 11,第 1 行
Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 2314885530818445312 (type Unknown), page (1:415656). Test (m_ghostRecCnt <= m_slotCnt) failed. Values are 25133 and 8224.
SQLServer 检测到基于一致性的逻辑 I/O 错误 页撕裂(签名应该为:0x55555555, 但实际为:0x00000001) 在文件‘D:\DATA\ERP_DATA.mdf’
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常见错误修复恢复。底层修复。技术支持。