在于BCP备份时报错!

系统:windows xp
数据库:sybase 11.9

小弟的数据库,可能是断电关机,损坏了,在重启数据库后,数据库报已经“置疑”,
我通过执行:
sp_configure "allow updates",1
        go
        reconfigure with override
        go
        update master..sysdatabases
        set status=-32768
        Where name="testdb"
        go
        shutdown with nowait
        go
在重启后,testdb库可以查询了,在用bcp 进行数据备份,想重新建库,但是在
bcp时,有许多表,并没有导出完成,在最后面出现了相似的错误如下:

其中一个表
。。。
29000 rows successfully bulk-copied to host-file.
30000 rows successfully bulk-copied to host-file.
31000 rows successfully bulk-copied to host-file.
Server Message:  - Msg 695, Level 21, State 1:
An attempt was made to read logical page '1025232' for object '800057936' in database '5' from disk. Wrong logical page '1537232' was brought into cache 'default data cache'.

Server Message:  - Msg 5702, Level 10, State 1:
The SQL Server is terminating this process.

另一个表
。。。
Starting copy...
1000 rows successfully bulk-copied to host-file.
2000 rows successfully bulk-copied to host-file.
Server Message:  - Msg 695, Level 21, State 1:
An attempt was made to read logical page '1024048' for object '280388068' in database '5' from disk. Wrong logical page '1536048' was brought into cache 'default data cache'.

Server Message:  - Msg 5702, Level 10, State 1:
The SQL Server is terminating this process.

我观察了下,发现,都是发生在第“5”号数据设备上,是不是,5号数据库设备有问题了呢!
在这个情况下,有办法修复吗?
请各位多多指教,谢谢!

作者: youwei   发布时间: 2011-03-16

如果数据不重要,那么可以将这两个相关的表drop掉,重新建后可以解决。
重要的话,需要一定的技术处理,有一定的难度。把那些没有导出来的数据导出来。

作者: hobbylu   发布时间: 2011-03-17