sybase數(shù)據(jù)庫系統(tǒng)表被破壞，如何修復(fù)？

black_chr

一臺服務(wù)器，估計(jì)是由于突然斷電的緣故，發(fā)現(xiàn)數(shù)據(jù)庫的系統(tǒng)表有被破壞的現(xiàn)象。執(zhí)行一些簡單的select語句，服務(wù)器的cpu占用率馬上是100%，查詢不出來。
dbcc檢查了系統(tǒng)表：
syscolumns，出來的提示是：
Checking dbo.syscolumns: Logical pagesize is 2048 bytes
Keys of index id 1 for table 'syscolumns' in data page not in correct order. Drop and re-create the index. (index page 100137)
Keys of index id 1 for table 'syscolumns' in data page not in correct order. Drop and re-create the index. (index page 100137)
Keys of index id 1 for table 'syscolumns' in data page not in correct order. Drop and re-create the index. (index page 100137)
Keys of index id 1 for table 'syscolumns' in data page not in correct order. Drop and re-create the index. (index page 100137)
Keys of index id 1 for table 'syscolumns' in data page not in correct order. Drop and re-create the index. (index page 100137)
Keys of index id 1 for table 'syscolumns' in data page not in correct order. Drop and re-create the index. (index page 100137)
Table Corrupt: Page linkage is not consistent; check the following pages: (current page#=49526;  page# pointing to this page=100137; previous page# indicated in this page=182461)
DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.

dbcc系統(tǒng)表syscomments，出來的提示是：
Checking dbo.syscomments: Logical pagesize is 2048 bytes
Table Corrupt: Page linkage is not consistent; check the following pages: (current page#=100195;  page# pointing to this page=43267; previous page# indicated in this page=31431)
DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.

請各位大俠看看，這是什么問題？應(yīng)該怎樣處理？謝謝。

njzh24

mark~
嘗試dbcc tablealloc  加fix選項(xiàng)修復(fù)下。

fishcoder

估計(jì)是DML操作的時(shí)候斷電了，索引page還沒有寫完就悲劇了~

2BeSybPro

關(guān)鍵的生產(chǎn)環(huán)境，一定要用備份恢復(fù)，手工操作不敢保證完全修復(fù)。實(shí)在沒有備份，就只有手工修復(fù)了。

hobbylu

建議先備份數(shù)據(jù)庫包括數(shù)據(jù)庫的備份和bcp的備份，然后再想其他的辦法，看是否能夠通過修改系統(tǒng)表頁面數(shù)據(jù)的方法來進(jìn)行修改等