4.在本地机器上实现远程备份：
/*"路径名\文件名"为远程备份服务器上的绝对路径文件*/
1>dump database XXXX to "路径名\文件名" at dbname_BS
2> go
在本地机器上恢复备份:
1>load database XXXXX to "路径名\文件名" at dbname_BS
2> go
注：
1.如果要实现远程的双向备份,请在远程机器上做与本地机器相同的配置.
2.本地的Backup Server的名称要求与远程的Backup Server的名称不一样.作者: earthman1 时间: 2007-04-30 11:12
select * into PLS_TEST from PLS_ORG97USERINFO
dump database xxxx to "/sybase_dump/xxxx.dmp" at bull020old_BS
go
Server Message: Number 3216, Severity 10
Line 1:
Backup Server session id is: 18. Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server.
Server Message: Number 501602, Severity 2
Server 'YUJING_new_BS', Procedure 'as_arch_device', Line 0:
Backup Server: 5.16.2.2: Client-Library error: Error number 3, Layer 6, Origin 8, Severity 5: ct_connect(): directory service layer: internal directory control layer error: Requested server name not found..
Server Message: Number 500302, Severity 2
Server 'YUJING_new_BS', Procedure 'as_arch_device', Line 0:
Backup Server: 5.3.2.1: Cannot open a connection to the slave site 'bull020old_BS'. Start the remote Backup Server if it is not running.
Server Message: Number 500702, Severity 2
Server 'YUJING_new_BS', Procedure 'bs_phase_map', Line 0:
Backup Server: 5.7.2.4: RPC ('as_arch_device') execution failed.
Server Message: Number 8009, Severity 16
Line 1:
Error encountered by Backup Server. Please refer to Backup Server messages for details.
sp_helpserver
go
name network_name class status id cost
---- ------------ ----- ------ -- ----
SYB_BACKUP YUJING_BS ASEnterprise timeouts, no net password encryption, writable , rpc security model A 1 NULL
SYB_EJB EJBServer ASEJB external engine auto start 2 NULL
YUJING_XP YUJING_XP ASEnterprise timeouts, no net password encryption, writable , rpc security model A 3 1000
bull020old_BS bull020old_BS ASEnterprise timeouts, no net password encryption, writable , rpc security model A 4 1000作者: 1017of 时间: 2007-04-30 11:52
first,check your sql.ini or interfaces to make sure the information is correct;
second,startup local backupserver and corresponding remote backupserver;
third,the version of remote backupserver must be newer than local one.
last,retry