Skip to Content
avatar image
Former Member

How to back up Advantage database using the adsbackup_utility.exe program?

I have an older version of the Advantage Database that my software runs on, Advantage 11.0. I need to find a way to backup that database singularly. I'm familiar with the process to backup a SQL database, and am wondering how to do something similar to that with Advantage. I've tried the instructions in the following document, but can't get it to run successfully. Any help would be appreciated! Thanks in advance.

http://devzone.advantagedatabase.com/dz/webhelp/advantage9.1/advantage_concepts/advantage_functionality/backup/adsbackup_utility.htm

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Apr 11 at 06:28 PM

    Thanks Michael. That it the syntax I'm using, but I think my problem is that I don't know the adssys password. Is there a default that I can try? From what I've read, it can't be recovered/reset...?

    Add comment
    10|10000 characters needed characters exceeded

    • The default adssys password is blank. We do not have a method of resetting or recovering a lost password.

      You only need the user password if the database is a data dictionary. If it is a folder of free tables, there is no user password, but you do need to provide the password of any encrypted tables.

      If you have a user with backup privileges and know that user's password, you can use the -y and -p switches together.

      Finally, if you can shut down the database, you can do a file copy. The only disadvantages of this are a short disruption of service, and the inability to follow up with differential backups.

      The specific error you are seeing would help.

      Mike Loop - SAP Product Support

  • Apr 12 at 11:17 AM

    Without a valid login, you can simply shut down ADS and make a file copy of the database folder.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 11 at 01:21 PM

    You can find the online help file for version 11 at Advantage Online Help Files, but the syntax hasn't changed much since version 9.

    Can you show us the syntax you have tried, and the error you received (change any passwords and server names, of course).

    As the help file shows, the simplest syntax would be:

    adsbackup -psecret c:\data\MyDB\MyDB.add c:\data\MyDB\backup

    You can also use Advantage Data Architect to initiate a one-time backup, or the stored procedure sp_BackupDatabase().

    Regards,

    Mike Loop
    Senior Product Support Engineer
    SAP Product Support

    Add comment
    10|10000 characters needed characters exceeded