How to configure SQL Server for remote backup?
The following describes the configuration method: (ASE version 12.0 or later)
On the local machine:
1. modify the interfaces file and add the Backup Server entry (Backup Server name, address, and port number) on the remote machine: the Server name cannot be an alias, And the UNIX platform can be added using the dscp utility, use dsedit utility to add
2. Add the remote Backup Server name in the sysservers system table
sp_addserver SYB_BACKUP,null,BACKUP_SERVER_NAMEgo
3. Use sp_helpserver to view at least three entries: Local ASE name, local Backup Server name, and Remote Backup Server Name
4. implement remote backup on the local machine:
dump database DATABASE_NAME to "remote_machine_path/..." at REMOTE_BACKUP_SERVER_NAMEgo
Recover the backup on the local machine:
load database DATABASE_NAME from "remote_machine_path/..." at REMOTE_BACKUP_SERVER_NAMEgo
Note:
1. To implement remote two-way backup, make the same configuration on the remote machine as that on the local machine.
2. The local Backup Server name must be different from the remote Backup Server name.