求助：数据库表坏了

donniejeck

数据库版本12.53,操作系统windows 2003
下午数据库服务器死机，重启动后ＤＢ状态可疑．通过dbcc rebuild_log后打开．dbcc tablealloc出错．数据表indid为２．故删除索引并重建．失败．
01:00000:00081:2009/11/06 18:40:34.10 server  Error: 12300, Severity: 20, State: 2
01:00000:00081:2009/11/06 18:40:34.10 server  Internal error: in table 'G_PNODES', database 4, the forwarded row (13002064, 13) pointed to by (12564122, 16) is invalid. Aborting the transaction.
01:00000:00083:2009/11/06 18:40:58.92 server  Error: 12300, Severity: 20, State: 2
01:00000:00083:2009/11/06 18:40:58.92 server  Internal error: in table 'G_PNODES', database 4, the forwarded row (13002064, 13) pointed to by (12564122, 16) is invalid. Aborting the transaction.
01:00000:00084:2009/11/06 18:41:07.85 server  Error: 12300, Severity: 20, State: 2
01:00000:00084:2009/11/06 18:41:07.85 server  Internal error: in table 'G_PNODES', database 4, the forwarded row (13002064, 13) pointed to by (12564122, 16) is invalid. Aborting the transaction.
02:00000:00085:2009/11/06 18:41:10.84 server  Error: 12300, Severity: 20, State: 2
02:00000:00085:2009/11/06 18:41:10.84 server  Internal error: in table 'G_PNODES', database 4, the forwarded row (13002064, 13) pointed to by (12564122, 16) is invalid. Aborting the transaction.

[ 本帖最后由 donniejeck 于 2009-11-6 19:18 编辑 ]

wfcjz

dbcc tablealloc结果出来的表，可以做个DBCC CHECKTALBE，用BCP把这个表数据导出来，然后DROP TABLE，再CREATE TABLE，然后再BCP进来！