Skip to Content
avatar image
Former Member

SQL Anywhere Backup Compatibility

I've been given a backup from a v11 server and need to restore it. When I start the restore I'm getting "The database archive ... could not be restored on the server ...", Backup file format is invalid, SQLCODE: -=716.

I've tried the restore on SQL Anywhere v16 and v12. I can't find anything about compatibility of backups between versions, is my only option to restore on v11?

I'd give v11 a try myself but even though download page for v11 exists (and I was emailed a license key), the download links themselves bring up a "this page is no longer available" screen.

-Tim Callaghan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 22, 2015 at 02:58 PM

    Can you describe how you backed up the database and how you are trying to restore it?

    I suspect that you're getting your image and archive backups mixed up, and you backed up using one method, and are trying to restore using the other.  Unless it's 1998 and you're backing up to tape, you should be using image backups.

    Add comment
    10|10000 characters needed characters exceeded

    • I've never used an archive backup, and I'm not sure if a v11 archive backup can be un-archived by a different version, and I don't know if it's encrypted whether that's an issue.  If you really want answers to using archive backups, let me know.

      The simplest way to get a copy of another database is to :

      1) Shut down the database engine cleanly

      2) Copy the database file to another location

      If you don't want to stop the database engine, you can take an image backup, which will include a database file and a transaction log.

      If it's a v11 database file, you should still be able to start it using the v16 engine.  If it's encrypted, you'll need to specify the encryption key.