Skip to Content

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

Apr 10 at 04:59 PM


avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

CCG Howells 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...?

Show 1 Share
10 |10000 characters needed characters left 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

Joachim Dürr 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.

10 |10000 characters needed characters left characters exceeded
Michael Loop
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().


Mike Loop
Senior Product Support Engineer
SAP Product Support

10 |10000 characters needed characters left characters exceeded