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.
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...?
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.
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.