DBCC CHECKDB出现13 allocation errors and 1 consistency errors

tolywang

DBCC CHECKDB (\'eFoxSFCMAX2\')    結果 :

CHECKDB found 9 allocation errors and 0 consistency errors not associated with any single object.
CHECKDB found 0 allocation errors and 1 consistency errors in table \'ALLOCATION\' (object ID 99).
CHECKDB found 2 allocation errors and 0 consistency errors in table \'mfworkorder\' (object ID 78779488
CHECKDB found 2 allocation errors and 0 consistency errors in table \'sfcscanerrlog\' (object ID 1532128799).

CHECKDB found 13 allocation errors and 1 consistency errors in database \'eFoxSFCMAX2\'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.   

首先，我们找不到 object ID 是 99 的表 ALLOCATION  , 下面两个倒是可以找到， 但是通过  

exec sp_dboption @dbname,\'single user\',\'true\'
dbcc checktable(\'需要修复的数据表的名称\',REPAIR_ALLOW_DATA_LOSS)
dbcc checktable(\'需要修复的数据表的名称\',REPAIR_REBUILD)
------把’ 需要修复的数据表的名称’更改为执行DBCC CHECKDB时报错的数据表的名称
exec sp_dboption @dbname,\'single user\',\'false\'

都没有办法修复那两个table, 想使用导出导入重新建立一个table,  也是报错 。




现在找到一种方法，准备再次测试一下 。  

DBCC CHECKDB(\'POS_DB\') with NO_INFOMSGS,PHYSICAL_ONLY
然后再运行：
DBCC CHECKDB(\'POS_DB\',repair_allow_data_loss) WITH TABLOCK

zfq308

頂一下，樓主測試成功了嗎？？？