SQL2014 Table error Object ID 0, index ID -1, partition ID 0, alloc unit ID 1093626870458482688 (type Unknown)

page (1 813264). Test (IS_OFF (BUF_IOERR, pBUF-bstat)) failed. Values are 133129 and -1



成功案例 【2020-12-19 09:09】




DBCC CheckDB检测错误如下:



DBCC results for 'XXXXXXXX'.

消息 8939,级别 16,状态 98,第 1 行

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 1093626870458482688 (type Unknown), page (1:813264). 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 -2386643636749860864 (type Unknown), page (35089:110028718). 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 -8189553778093522944 (type Unknown), page (8010:-1950592501). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -12.

消息 8939,级别 16,状态 98,第 1 行

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 4935053699676307456 (type Unknown), page (63179:-1409404947). 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 5607280752399876096 (type Unknown), page (8844:1383563792). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -10.

消息 8939,级别 16,状态 98,第 1 行

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 6498926558803329024 (type Unknown), page (53569:1805173556). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -10.

消息 8939,级别 16,状态 98,第 1 行

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057594044416000 (type Unknown), page (1:884016). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.

消息 8909,级别 16,状态 1,第 1 行

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057594044416000 (type Unknown), page ID (1:884017) contains an incorrect page ID in its page header. The PageId in the page header = (1:373487).

消息 8909,级别 16,状态 1,第 1 行

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057594044416000 (type Unknown), page ID (1:884018) contains an incorrect page ID in its page header. The PageId in the page header = (1:373488).

消息 8909,级别 16,状态 1,第 1 行

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057594044416000 (type Unknown), page ID (1:884019) contains an incorrect page ID in its page header. The PageId in the page header = (1:373489).

消息 8909,级别 16,状态 1,第 1 行

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057594044416000 (type Unknown), page ID (1:884020) contains an incorrect page ID in its page header. The PageId in the page header = (1:373490).

消息 8909,级别 16,状态 1,第 1 行

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057594044416000 (type Unknown), page ID (1:884021) contains an incorrect page ID in its page header. The PageId in the page header = (1:373491).

消息 8909,级别 16,状态 1,第 1 行

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057594044416000 (type Unknown), page ID (1:884022) contains an incorrect page ID in its page header. The PageId in the page header = (1:373492).

消息 8909,级别 16,状态 1,第 1 行

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057594044416000 (type Unknown), page ID (1:884023) contains an incorrect page ID in its page header. The PageId in the page header = (1:373493).

消息 8909,级别 16,状态 1,第 1 行

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057594044416000 (type Unknown), page ID (1:888521) contains an incorrect page ID in its page header. The PageId in the page header = (1:373694).

消息 8909,级别 16,状态 1,第 1 行

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057594044416000 (type Unknown), page ID (1:888522) contains an incorrect page ID in its page header. The PageId in the page header = (1:373695).

消息 8909,级别 16,状态 1,第 1 行

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057594044416000 (type Unknown), page ID (1:888523) contains an incorrect page ID in its page header. The PageId in the page header = (1:373696).

消息 8909,级别 16,状态 1,第 1 行

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057594044416000 (type Unknown), page ID (1:888524) contains an incorrect page ID in its page header. The PageId in the page header = (1:373697).

消息 8909,级别 16,状态 1,第 1 行

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 72057594044416000 (type Unknown), page ID (1:888525) contains an incorrect page ID in its page header. The PageId in the page header = (1:373698).

消息 8939,级别 16,状态 98,第 1 行

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID -4475563926512861184 (type Unknown), page (1:813296). 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 3855092107366694912 (type Unknown), page (62587:1267606). 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 6306461405881368576 (type Unknown), page (61606:1589393886). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -12.

消息 8939,级别 16,状态 98,第 1 行

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 1295693363338805248 (type Unknown), page (20167:2099313432). 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 6030012222132977664 (type Unknown), page (3655:650925291). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -4.

消息 8909,级别 16,状态 1,第 1 行

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 2756489246800216064 (type Unknown), page ID (1:813301) contains an incorrect page ID in its page header. The PageId in the page header = (57306:431594554).

消息 8909,级别 16,状态 1,第 1 行

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 5218392239016640512 (type Unknown), page ID (1:813302) contains an incorrect page ID in its page header. The PageId in the page header = (33980:1771445845).

消息 8939,级别 16,状态 98,第 1 行

Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 9003418881545797632 (type Unknown), page (23021:1597062430). 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 6269138226074615808 (type Unknown), page (1:884240). 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 5476503592145780736 (type Unknown), page (16640:1543533312). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 133129 and -14.




001.png




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常见错误修复恢复。底层修复。技术支持。





友情链接:
速全科技

——MS SQL Server数据库修复专家——

24小时服务热线:18620906802

QQ:80554803 邮箱:80554803@qq.com

sql修复,sql损坏,mdf修复,mdf损坏,sql置疑, 数据库置疑

sql修复,sql损坏,mdf修复,mdf损坏,sql置疑, 数据库置疑

豫ICP备19030104号-1