网站 › 『 Sybase ASE 』 › sybase数据库备份的问题

ztchenj 发表于 2007-6-27 14:50:34

sybase数据库备份的问题

<p>小弟菜鸟，第一次发贴求助，请大家帮忙。</p><p>我用的sybase11.9.2 的数据库(win2K的系统)，在用dump 命令备份数据库时出了点状况。</p><p>对话框提示如下：</p><p>&nbsp;E:\cwdata&gt;c:\sybase\bin\isql -Usa -P -ie:\cwdata\backup7.sql</p><p>&nbsp;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。</p><p>&nbsp;Backup Server：6.38.1.1：Header labels of the volume on 'e:\cwdata\7\cwbase1.dup'：</p><p>&nbsp;Backup Server：6.34.2.5：</p><p>&nbsp;VOL1</p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;4</p><p>&nbsp;HDR1cwbase1070980A8CA00010100010000000100&nbsp; 07098&nbsp; 07098</p><p></p><p>Backup Server:64.49.1.1:OPERATOR:Uolume to be overwritten on e:\cwdata\7\cwbasel.dump has not expired:creation date on this volume is Backup Server:6.78.1.1<br/>&nbsp;EXECUTE sp-volchanged<br/>@session-id=5<br/>@devname<br/>e:\cwdate\7\cwbase1.dump<br/>@action={PROCEED|RETER|ABORT}</p><p></p><p></p><p></p>

ehxz 发表于 2007-6-28 11:03:54

e:\cwdata\backup7.sql这个文件的内容提供一下参考

ztchenj 发表于 2007-6-28 14:44:38

<p>sql 文件的内容如下：</p><p>use master</p><p>go</p><p>dump database cwbase1 to 'e:\cwdata\7\cwbase7.dump'</p><p>go</p><p>exit</p><p></p><p>&nbsp;</p>

查看完整版本: sybase数据库备份的问题