緊急求助SYBASE MSG 695 問題

niugang2002

數(shù)據(jù)庫掉電后進(jìn)入recovery狀態(tài)，手工恢復(fù)后檢查表
   部分表出現(xiàn)如下錯誤：
  1>; dbcc checktable(table1)
    2>;go
   MSG 695,level 16,state 1:
    line 1:
   an attempt was made to read logical page'2047386' for object'1590296725' in database '4' from disk.wrong logical page '2047442' was brought into cache 'default data cache'
   DBCC execution completed . if DBCC printed error messages,contant a user with system administrator role

小無賴

把這個表bcp出來，然后試著帶參數(shù)修復(fù)一下，不行的話就把表重建一遍，再bcp進(jìn)去.

chenfeng825

如果能夠讀出來是最好了，可能他現(xiàn)在讀不出了。建議看看'故障和恢復(fù)手冊‘比較保險。生產(chǎn)系統(tǒng)安全點放心