Skip to Content

SAP Suite on Sybase Backup

Dear Experts,

I have installed SAP on ASE and can see below database in DBAcockpit.

So from a restore point of view pleas let me know which database backup is necessary for a secure restore and recovery.For SID database i have already scheduled the log and databaackup.

capture.png (73.6 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    Posted on Jun 25, 2020 at 06:20 AM

    Dear Mr Nagar

    Please review SAP Notes

    1585981 SYB: Ensuring Recoverability for Sybase ASE

    1611715 SYB: How to restore a Sybase ASE database server (Windows)

    1618817 SYB: How to restore a Sybase ASE database server (UNIX)

    1887068 SYB: Using external backup and restore with SAP Sybase ASE

    maybe also :

    1801984 SYB: Automated management of long running transactions

    these provide an overview of the tasks and serve as a starting point for your own backup concept that suits the needs of your organisation.

    In any case I strongly suggest to test restore on a regular basis - so to verify it actually works.

    With kind regards
    Tilman Model-Bosch

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 25, 2020 at 05:59 AM

    Hi Prashant.

    1. For Daily you have to take the SID backup & based on your business need you can clear the logs.

    2. For Weekly & monthly you have to take full database backup including SID.

    In our environment we are following the same way.

    Regards

    SS

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 25, 2020 at 01:29 PM

    Good answers colls.

    Prashant,

    you can also check:

    1588316 - SYB Configure automatic database and log backups
    1841993 - How to schedule backups in DBACOCKPIT - SAP ASE for Business Suite
    2497314 - How to recreate database saptools when it is corrupted and no clear backup - SAP ASE for Business Suite
    1928596 - How to remove a defunct backup server process - SAP ASE

    Check if this process are up and running
    ps -ef | grep dataserver
    ps -ef | grep backupserver

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 23, 2020 at 06:22 AM

    Hi Prashant.

    I am not sure about ASE DB. In our environment MS Sql we have SID & Ms Sql default DB's (Master & Temp db's), for normal days we use to take backup only SID db, weekly & monthly take full database included default db's in one go, we have using third party backup software in that one go you can select DB & also SAP usr folders using the third party backup tool Veritas backup tool

    Regards

    SS

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.