This procedure is needed to allow the Adaptive Server that is being recovered to access its Backup Server. If this step is not performed when needed, then Adaptive Server will not be able to process any dump or load commands.
As a Sybase System Administrator (“sa_role”), execute the following commands in an isql session on the Adaptive Server that is being recovered:
1> use master 2> go
1> select srvname, srvnetname from sysservers 2> where srvname = "SYB_BACKUP" 3> go
There are three possible outcomes to this query. The following table matches each outcome to the steps you should take in that circumstance:
Outcome |
Action |
|---|---|
Adaptive Server returns a single row and the srvnetname column contains the correct reference for the Backup Server |
No further action is needed |
Adaptive Server returns a single row but the srvnetname column does not contain the correct reference |
Issue the following commands: 1> update sysservers 2> set srvnetname = “backup_server_name” 3> where srvname = “SYB_BACKUP” 4> go
where backup_server_name is the name of the Backup Server as it appears in the interfaces file. |
Adaptive Server returns 0 rows |
Issue the following command: 1> sp_addserver SYB_BACKUP, null, 2> backup_server_name 3> go
where backup_server_name is the name of the Backup Server as it appears in the interfaces file. |
