紧急求助SYBASE MSG 695 问题

niugang2002

数据库掉电后进入recovery状态，手工恢复后检查表
   部分表出现如下错误：
  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出来，然后试着带参数修复一下，不行的话就把表重建一遍，再bcp进去.

chenfeng825

如果能够读出来是最好了，可能他现在读不出了。建议看看'故障和恢复手册‘比较保险。生产系统安全点放心