dump与load 的问题

WEIJX 2003-07-08 09:35:50
本人单位有一财务数据库用dump备份出来后再用load 恢复，不能完成，出现下面的最后行后，就死了。不知如何解决,盼高手指教,多谢!


Server Message: Number 3216, Severity 10
Backup Server session id is: 5. Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server.
Server Message: Number 602801, Severity 1
Backup Server: 6.28.1.1: Dumpfile name 'wbase18031890823C' section number 0001 mounted on disk file 'd:\w07'
Server Message: Number 405801, Severity 1
Backup Server: 4.58.1.1: Database cwbase4: 11026 kilobytes LOADed.
Server Message: Number 405801, Severity 1
Backup Server: 4.58.1.1: Database cwbase4: 21830 kilobytes LOADed.
Server Message: Number 405801, Severity 1
Backup Server: 4.58.1.1: Database cwbase4: 34864 kilobytes LOADed.
Server Message: Number 405801, Severity 1
Backup Server: 4.58.1.1: Database cwbase4: 43244 kilobytes LOADed.
Server Message: Number 405801, Severity 1
Backup Server: 4.58.1.1: Database cwbase4: 57114 kilobytes LOADed.
Server Message: Number 405801, Severity 1
Backup Server: 4.58.1.1: Database cwbase4: 74406 kilobytes LOADed.
Server Message: Number 405801, Severity 1
Backup Server: 4.58.1.1: Database cwbase4: 87058 kilobytes LOADed.
Server Message: Number 405801, Severity 1
Backup Server: 4.58.1.1: Database cwbase4: 101892 kilobytes LOADed.
Server Message: Number 405801, Severity 1
Backup Server: 4.58.1.1: Database cwbase4: 107630 kilobytes LOADed.
Server Message: Number 405801, Severity 1
Backup Server: 4.58.1.1: Database cwbase4: 112714 kilobytes LOADed.
Server Message: Number 405801, Severity 1
Backup Server: 4.58.1.1: Database cwbase4: 123236 kilobytes LOADed.
Server Message: Number 405801, Severity 1
Backup Server: 4.58.1.1: Database cwbase4: 134488 kilobytes LOADed.
Server Message: Number 405801, Severity 1
Backup Server: 4.58.1.1: Database cwbase4: 146232 kilobytes LOADed.
Server Message: Number 405801, Severity 1
Backup Server: 4.58.1.1: Database cwbase4: 167994 kilobytes LOADed.
Server Message: Number 405801, Severity 1
Backup Server: 4.58.1.1: Database cwbase4: 211006 kilobytes LOADed.
Server Message: Number 405801, Severity 1
Backup Server: 4.58.1.1: Database cwbase4: 254526 kilobytes LOADed.
Server Message: Number 405801, Severity 1
Backup Server: 4.58.1.1: Database cwbase4: 257026 kilobytes LOADed.
Server Message: Number 405801, Severity 1
Backup Server: 4.58.1.1: Database cwbase4: 266610 kilobytes LOADed.
Server Message: Number 405801, Severity 1
Backup Server: 4.58.1.1: Database cwbase4: 288514 kilobytes LOADed.
Server Message: Number 405801, Severity 1
Backup Server: 4.58.1.1: Database cwbase4: 300184 kilobytes LOADed.
Server Message: Number 405801, Severity 1
Backup Server: 4.58.1.1: Database cwbase4: 307774 kilobytes LOADed.
Server Message: Number 405801, Severity 1
Backup Server: 4.58.1.1: Database cwbase4: 319534 kilobytes LOADed.
Server Message: Number 405801, Severity 1
Backup Server: 4.58.1.1: Database cwbase4: 358004 kilobytes LOADed.
Server Message: Number 405801, Severity 1
Backup Server: 4.58.1.1: Database cwbase4: 401012 kilobytes LOADed.
Server Message: Number 405801, Severity 1
Backup Server: 4.58.1.1: Database cwbase4: 444024 kilobytes LOADed.
Server Message: Number 405801, Severity 1
Backup Server: 4.58.1.1: Database cwbase4: 487544 kilobytes LOADed.
Server Message: Number 405801, Severity 1
Backup Server: 4.58.1.1: Database cwbase4: 530556 kilobytes LOADed.
Server Message: Number 405801, Severity 1
Backup Server: 4.58.1.1: Database cwbase4: 574076 kilobytes LOADed.
Server Message: Number 405801, Severity 1
Backup Server: 4.58.1.1: Database cwbase4: 614526 kilobytes LOADed.
Server Message: Number 405801, Severity 1
Backup Server: 4.58.1.1: Database cwbase4: 614534 kilobytes LOADed.
Server Message: Number 304201, Severity 1
Backup Server: 3.42.1.1: LOAD is complete (database cwbase4).
Server Message: Number 5018, Severity 10
Caution: You have set up this database to include space on disk 6 for both data and the transaction log. This can make recovery impossible if that disk fails.
Server Message: Number 3127, Severity 10
All dumped pages have been loaded. SQL Server is now clearing pages above page 307200, which were not present in the database just loaded.
Server Message: Number 3128, Severity 10
SQL Server has finished clearing database pages.
...全文
47 3 打赏 收藏 转发到动态 举报
写回复
用AI写文章
3 条回复
切换为时间正序
请发表友善的回复…
发表回复
stweiguo 2003-07-10
  • 打赏
  • 举报
 回复
把你的dump 和 load 的语句写出来
小潜s 2003-07-10
  • 打赏
  • 举报
 回复
Caution: You have set up this database to include space on disk 6 for both data and the transaction log. This can make recovery impossible if that disk fails.
hflin1112 2003-07-10
  • 打赏
  • 举报
 回复
是不是日志满了，造成数据无法导入！建议把日志空间扩大！
dump、load和dumps、loads的联系与区别
dump、load和dumps、loads的联系与区别 1、dump:将dict(字典)转换为str(字符串),并写入json文件中。 import json Dict={'1':1,'一':'一'} json.dump(Dict,open('json.json','w',ensure_ascii=False) #ensure_ascil=False表示输出中文，不加这句话就将字典的的中...
Python Json模块中dumps、loads、dump、load函数介绍
本篇文章主要介绍了Python Json模块中dumps、loads、dump、load函数介绍，详细的介绍了这几种函数的用法，具有一定的参考价值，感兴趣的小伙伴们可以参考一下 Json模块dumps、loads、dump、load函数介绍 1、json.dumps() json.dumps()用于将dict类型的数据转成str，因为如果直接将dict类型的数据写入json文件中会发生报错，因此在将数据写入时需要用到该函数。 1 2 3 4 5 6 .
dumps ,loads,dump,load区别
json.dumps(): 将python数据转化为json数据，如图。 json.loads(): 将json数据转化为python数据类型，如图 这个没什么疑问，但dump和load又是什么呢？这个网上就有很多不同的说法了。不追究细节的话： dump是把数据写入文件 load是从文件读取数据 把python数据写入到文件 把json数据写入到文件： 两个文件都可以写出来，亦有差别。（可见网上有些说，只能写json的说法不对。） 我的感觉就是都可以写入文件。 load分别读取两个文件：
python—pickle模块的dump与load函数
  如果你需要将一个Python对象序列化为一个字节流，以便将它保存到一个文件、存储到数据库，那么最常用的做法就是使用 pickle 模块。   对于大多数应用程序来讲，dump() 和 load() 函数的使用就是你有效使用 pickle 模块所需的全部了。 它可适用于绝大部分Python数据类型和用户自定义类的对象实例。 如果你碰到某个库可以让你在数据库中保存/恢复Python对象或者是通过网络传输对象的话， 那么很有可能这个库的底层就使用了 pickle 模块。   pickle模块可以保存序列甚至是
SVN备份及其还原 — dump/load方法
SVN备份及其还原 — dump/load方法本文中采用最简单的dump/load方法。 备份： 一个较大的Subsersion版本库想用最少的空间来将它备份下来，用这个命令(请将/repo替换成你的版本库路径) svnadmin dump --deltas /repos |bzip2 |tee dump.bz2 | md5sum >dump.md5 最重要的一步是 -deltas,将...
Sybase

2,596

社区成员

25,614

社区内容

发帖
与我相关
我的任务
社区描述
Sybase相关技术讨论区
社区管理员
  • Sybase社区
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章