- 论坛徽章:
- 0
|
本人在做dump的过程中,按以下步骤做:
假设本地为A,远程为B
1.在A建立数据库服务SQL_A,备份服务BACK_A
2.在B建立SQL_B和BACK_B
3.在A和B中修改配置
>;sp_configure "allow remote access",1
>;go
4.在A的interfaces中增加BACK_B
5.在SQL_A中
>;sp_addserver BACK_B
>;go
6.在SQL_A中执行远程备份
>;dump database db_name to "/../../xx.data" at BACK_B
>;go
且两边的密码都是一样的,我个人认为步骤应该没有错,但还是做不了,报了以下错误:
Server Message: Number 3216, Severity 10
Server 'SMCHUADU', Line 1:
Backup Server session id is: 14. 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 'SMCHUADU_BS', Procedure 'as_arch_device', Line 0:
Backup Server: 5.16.2.2: DB-Library error, error number 20014, severity 2: Login incorrect.
Server Message: Number 500302, Severity 2
Server 'SMCHUADU_BS', Procedure 'as_arch_device', Line 0:
Backup Server: 5.3.2.1: Cannot open a connection to the slave site 'KALVIN_BS'.
Server Message: Number 8009, Severity 16
Server 'SMCHUADU', Line 1:
Error encountered by Backup Server. Please refer to Backup Server messages for details.
麻烦各位指点迷津?对了,我用的版本是11.9.2,我是在windows下做dump的 |
|