在于BCP备份时报错!
时间:2011-03-16
来源:互联网
系统: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号数据库设备有问题了呢!
在这个情况下,有办法修复吗?
请各位多多指教,谢谢!
数据库: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
热门阅读
-
office 2019专业增强版最新2021版激活秘钥/序列号/激活码推荐 附激活工具
阅读:74
-
如何安装mysql8.0
阅读:31
-
Word快速设置标题样式步骤详解
阅读:28
-
20+道必知必会的Vue面试题(附答案解析)
阅读:37
-
HTML如何制作表单
阅读:22
-
百词斩可以改天数吗?当然可以,4个步骤轻松修改天数!
阅读:31
-
ET文件格式和XLS格式文件之间如何转化?
阅读:24
-
react和vue的区别及优缺点是什么
阅读:121
-
支付宝人脸识别如何关闭?
阅读:21
-
腾讯微云怎么修改照片或视频备份路径?
阅读:28