on 04-10-2018 5:59 PM
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.
Without a valid login, you can simply shut down ADS and make a file copy of the database folder.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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...?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.