Skip to main content
commvault.com commvault.com
Solved

Sybase Backup failing

  • August 18, 2023
  • 4 replies
  • 2099 views
R
Novice
Forum|alt.badge.img+7

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

    4 replies

    Rajiv
    Vaulter
    Forum|alt.badge.img+12
    • RajivVaulter
    • Vaulter
    • 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

    R
    Novice
    Forum|alt.badge.img+7
    • Rahul18081Novice
    • Author
    • Novice
    • 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
    • RajivVaulter
    • Vaulter
    • 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

    T
    Vaulter
    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.

    Terms & ConditionsCookie settingsAccessibility statement