To use the dump and load commands, an Adaptive Server must be able to communicate with its Backup Server. These are the requirements:
Backup Server must be running on the same machine as the Adaptive Server (or on the same cluster for OpenVMS).
Backup Server must be listed in the master..sysservers table. The Backup Server entry, SYB_BACKUP, is created in sysservers when you install Adaptive Server. Use sp_helpserver to see this information.
Backup Server must be listed in the interfaces file. The entry for the local Backup Server is created when you install Adaptive Server. The name of the Backup Server listed in the interfaces file must match the column srvnetname name for the SYB_BACKUP entry in master..sysservers. If you have installed a remote Backup Server on another machine, create the interfaces file on a file system that is shared by both machines, or copy the entry to your local interfaces file. The name of the remote Backup Server must be the same in both interfaces files.
The user who starts the Backup Server process must have write permission for the dump devices. The “sybase” user, who usually starts Adaptive Server and Backup Server, can read from and write to the database devices.
Adaptive Server must be configured for remote access. By default, Adaptive Server is installed with remote access enabled. See “Configuring your server for remote access”.
