Skip to main content
Solved

Sybase Backup failing


Forum|alt.badge.img+8

Hi All,

 

Getting below error when running backup for Sybase database.

 

              Error Code: [71:30]
Description: Error while running a command on Sybase server :[Can't open a connection to site 'SYB_BACKUP'. See the error log file in the ASE boot directory. Can't open a connection to site 'SYB_BACKUP'. See the error log file in the ASE boot directory. Could not establish communication with Backup Server 'SYB_BACKUP'. Please make sure that there is an entry in Sysservers for this server, and that the correct server is running. DUMP DATABASE XP1 FULL is unable to clear the list of changed database pages. Future incremental dumps will be unnecessarily large until the next successful full DUMP DATABASE. ]

Best answer by Rajiv

@Rahul18081 I believe your Sybase backup server is SYB_BACKUP. You have to edit the command run accordingly. 

 

ps -ef | grep -i “SYB_BACKUP”

 

If no output comes up, as I mentioned earlier, please work with your DBA to start the server and then re-run the backup.

Best,

Rajiv Singal

View original
Did this answer your question?

4 replies

Rajiv
Vaulter
Forum|alt.badge.img+12
  • Vaulter
  • 323 replies
  • August 18, 2023

@Rahul18081 You have to ensure Sybase Backup server is started and running on the Sybase side.

-- The below 2 commands can give the output whether the Sybase backup server is running or not:

ps -ef | grep -i server

ps -ef | grep -i backupserver

 

-- If the Sybase backup server is not running, please request DBA team to start the server and then re-run the backup.

Best,

Rajiv Singal


Forum|alt.badge.img+8
  • Author
  • Byte
  • 38 replies
  • August 18, 2023

@Rajiv please see the below output of the above command u mentioned. Please update why no backup server info is showing when running the command.

kgxfrpdpoa01:~ # ps -ef | grep -i server
sybxp1    4795  4793  0 May23 ?        04:34:38 /sybase/XP1/DM/REP-16_0/bin/repserver -SXP1_REP_PRIM -C/sybase/XP1/DM/XP1_REP_PRIM/XP1_REP_PRIM.cfg -E/sybase/XP1/DM/XP1_REP_PRIM/XP1_REP_PRIM.log -I/sybase/XP1/DM/interfaces
root      6126  5936  0 10:37 pts/2    00:00:00 grep --color=auto -i server
sybxp1   19826 19825 34 May21 ?        30-10:44:39 /sybase/XP1/ASE-16_0/bin/dataserver -d/sybase/XP1/sybsystem/master.dat -e/sybase/XP1/ASE-16_0/install/XP1.log -c/sybase/XP1/ASE-16_0/XP1.cfg -M/sybase/XP1/ASE-16_0 -N/sybase/XP1/ASE-16_0/sysam/XP1.properties -i/sybase/XP1 -sXP1
kgxfrpdpoa01:~ # ps -ef | grep -i backupserver
root      6218  5936  0 10:37 pts/2    00:00:00 grep --color=auto -i backupserver
kgxfrpdpoa01:~ #


Rajiv
Vaulter
Forum|alt.badge.img+12
  • Vaulter
  • 323 replies
  • Answer
  • August 18, 2023

@Rahul18081 I believe your Sybase backup server is SYB_BACKUP. You have to edit the command run accordingly. 

 

ps -ef | grep -i “SYB_BACKUP”

 

If no output comes up, as I mentioned earlier, please work with your DBA to start the server and then re-run the backup.

Best,

Rajiv Singal


Forum|alt.badge.img+4

Hello @Rahul18081 

 

Step 1:- Please make sure the Sybase backup server is up and running. http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc31644.1550/html/sag2/X62910.htm

 

Step 2: If the sybase backup server is already up, then the issue could be related to the below SAP note:- https://launchpad.support.sap.com/#/notes/0001908208

 

Sybase services restart may help to fix the issue.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings