Sybase - ReCreating SYB_BACKUP server

01. Stop Backup Service. i.e. Sybase SQLServer_[ASE]_BS.
02. Remove Backup Server using Server Config ($SYBASE\ASE-12_5\BIN\SYCONFIG.exe).
03. Remove file "Run_[ASE]_BS.bat". Or renamed it to "Run_[ASE]_BS.bat.orig".
04. Remove Backup Server mapping from master..sysservers using sp_dropserver SYB_BACKUP command.
05. Stop SQL Service i.e. Sybase SQLServer_[ASE].
06. Restart Machine.
07. Start SQL Service. Backup service is still exist in the "Services" window.
08. Remark Backup Server entries in $SYBASE\ini\SQL.ini or delete them.
09. Create Backup Server using Server Config.
10. Check SQL.ini. There should be new entries created for Backup Server. Ping it using DSEDIT utility ($SYBASE\OCS-12_5\BIN\DSEDIT.exe).
11. Insert SYB_BACKUP server into master..sysservers table by running below script. Must be 'sa' or user with 'sa_role' to run it.
12. Test Dump master DB.
13. When failed, excalate the issue.

Related Links :
www.sybase.com
www.sypron.nl

Terms :
ASE stands for Adaptive Server Enterprise. It is practically the Sybase Server Instance