Skip to Content

Runing Sybase backup without writing down password in batch file

Hi experts,

I recently started working with SAP Sybase ASE and am trying to find a way to run full backup by batch file in background.

I have done the reserch and learned "dump database" is the SQL command to take full backup of database.
However, before run the SQL, I need to logon to the database and it needs username and password.

I don't want to write down password directly in batch file for the security aspect.
And I know external authentification can be used in isql, but it takes a lot of efforts to me.

Is there any way to take full backup of database in easier way?
Thank you.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on Jun 10, 2019 at 03:10 AM

    You can use the Job Scheduler feature to kick off a backup at a certain time.

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Bret,

      Job Scheduler doesn't work out for me because I want to control when to backup using 3rd party job management software.
      Backup need to be run after a certain event, so time-base job scheduling was not a option for me.
      However, thank you for your answer!

  • Posted on Jun 12, 2019 at 01:38 PM

    Are you on ASE 16.0 SP03 - then there is a new feature 'ASE Secure User Store' - see https://help.sap.com/viewer/2705a3b1e3df4514ab089cfedf87750d/16.0.3.7/en-US/740b5062301c48f4aa739e6c6fb6cd62.html

    If you are using an ABAP system you may use R3 kernel tool "sybctrl" to execute scripts in ASE. See SAP note https://launchpad.support.sap.com/#/notes/1899984

    With kind regards
    Tilman Model-Bosch

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 13, 2019 at 11:58 AM

    What OS is your client running in? (that runs the backup command). Eg. Linux shell?

    Also for the 'ASE Secure User Store', instead of a username/password, it needs a "user-generated key" to lookup the username/password. So you still need a secure way to pass in the key to the client program, right? Ie., if somebody steals the "user-generated key", then they have access, just like having the password, right?

    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.