- 论坛徽章:
- 0
|
平台xp sp2 ase12.5
实验目标:远程备份
步骤:
1.假设本地为A,远程为B,启动A的主服务备份服务
2.在A中执行sp_configure "allow remote access",1
3.在A的INI文件中增加B的备份服务器,并执行sp_addserver BACK_B(B的备份服务)
4.然后执行dump database db_name to "/../../xx.data" at BACK_B
5.如果对方有防火墙将会出现以下错误!
request from the Backup Server.
Backup Server: 5.16.2.2: Client-Library error: Error number 4, Layer 5, Origin
3, Severity 5: ct_connect(): network packet layer: internal net library error:
Net-Lib protocol driver call to connect two endpoints failed.
Backup Server: 5.3.2.1: Cannot open a connection to the slave site 'MONKhk_BS'.
Start the remote Backup Server if it is not running.
Msg 8009, Level 16, State 1:
Line 1:
Error encountered by Backup Server. Please refer to Backup Server messages for
details.
注:如果在没有防火墙并且本地打开了allow remote access,将可以无限制的在远程B上写备份文件,如果有恶意破坏行径者,可以写批处理把B的磁盘占满( ) |
|