东子哥哥 发表于 2009-03-24 12:00

dbcc checktable()的报错求解决方法

dbcc报的错如下,如何解决啊???
1> dbcc checktable(mgb)
2> go
Checking mgb: Logical pagesize is 2048 bytes
Msg 2503, Level 16, State 1:
Server 'newappv9', Line 1:
Table Corrupt: Page linkage is not consistent; check the following pages:
(current page#=831534;page# pointing to this page=57769; previous page#
indicated in this page=831533)
DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.

chuxu 发表于 2009-03-24 12:38

是否当时有人在使用这个表?

camham 发表于 2009-03-24 13:22

dbcc tablealloc尝试修复,如果失败重建表吧
页: [1]
查看完整版本: dbcc checktable()的报错求解决方法