Log in to the server as “sa,” using a null password.
If the network name of your Backup Server is not SYB_BACKUP, you must update sysservers so that Adaptive Server can communicate with its Backup Server. Check the Backup Server name in your interfaces file, and issue this command:
select * from sysservers where srvname = "SYB_BACKUP"
Check the srvnetname in the output from this command. If it matches the interfaces file entry for the Backup Server for your server, go to “Step 6: Verify that your Backup Server is running”.
If the reported srvnetname is not the same as the Backup Server in the interfaces file, you must update sysservers. The example below changes the Backup Server’s network name to PRODUCTION_BSRV:
begin transaction update sysservers set srvnetname = "PRODUCTION_BSRV" where srvname = "SYB_BACKUP"
Execute this command, and check to be sure that it modified only one row. Issue the select command again, and verify that the correct row was modified and that it contains the correct value. If update modified more than one row, or if it modified the wrong row, issue a rollback transaction command, and attempt the update again.
If the command correctly modified the Backup Server’s row, issue a commit transaction command.
