Recovery for SQL Anywhere

The effective way to find out if a SQL Anywhere Server database is recoverable is to try the demo version of Recovery for SQL Anywhere on it. Visit the Demo page for a free copy of the demo.

Product specifications with lists of items recovered and not recovered is available at the Product Information page.

Note: Always backup your original corrupted SQL Anywhere Server database before proceeding with any recovery activity!

Note that no additional table or record or any other elements and features of the original database will be restored by commercial version of Recovery for SQL Anywhere if not present in demo output.

Evaluating the results of demo recovery can help in making the decision.

Details of current licensing scheme are described at the Licensing page.

If your license type is Enterprise or Service, you can run Recovery for SQL Anywhere from command line and use these calls in your batch files. Standard version does not support command line. The format for command line call is:

sar.exe <original filename with path> "<path to directory to store the recovered file(s)>"

Please note that the directory for recovered file(s) should be created before starting the recovery.

Command line mode supports patterns '*' (replaces group of symbols) and '?' (replaces one symbol).

To recreate database, process resulting sql scripts starting with schema.sql and following by dataNNNN.sql. The database will be recreated from scratch.

To make the import procedure more convenient for the end-user an appropriate batch file is automatically created and put in the same folder as sql script(s).