cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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_functional...

Accepted Solutions (0)

Answers (3)

Answers (3)

joachim_drr
Contributor
0 Kudos

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

Former Member
0 Kudos

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

michael_loop
Contributor
0 Kudos

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

michael_loop
Contributor
0 Kudos

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