Table Corrupt: Attempted to get page 2816, object 99; got page 0, object 0.

wx896138

在恢复时和SYBASE服务启动时出现时以下错误,然后数据库标记为"SUSPECT"
server  Error: 692, Severity: 20, State: 1
server  Uninitialized logical page '2817' was read while accessing object '1' in database '4'. Please contact Sybase Technical Support.

用DBCC TABLEALLOC (tablename,full,fix)时,出现以下错误
TABLE: sysobjects               OBJID = 1
Msg 2529, Level 16, State 12:
Line 1:
Table Corrupt: Attempted to get page 2816, object 99;  got page 0, object 0.

谁能告诉我如何解决啊!谢谢!

yaledu

既然是sysobjects,你删也删不来
把status改-32768，把数据BCP出来，重新建库BCP回去吧。