- 论坛徽章:
- 0
|
1> dbcc tablealloc(table_name,full,fix)
2> go
Page linkage failed for OBJID 121453729 INDID 0; Processed 1698835
pages;
***************************************************************
TABLE: table_name OBJID = 121453729
INDID=0 FIRST=1169 ROOT=64472667 SORT=0
Msg 2529, Level 16, State 7:
Server 'pub2', Line 1:
Table Corrupt: Attempted to get page 64472666 , object 121453729; got page 0,
object 0.
INDID=2 FIRST=89080 ROOT=89082 SORT=1
The oam counts for objid 121453729 indid 2 are corrected.
Indid : 2. 524466 Index pages allocated and 68714 Extents allocated
.
TOTAL # of extents = 68714
实在是没办法可想了,重启,DBCC,该做的都做了,还是修复不了那个logic page,高手们帮我看看还能怎么办,先谢谢了 |
|