Can Recovery for SQL Anywhere successfully repair or restore my database?
In many cases, Recovery for SQL Anywhere can fully restore damaged, corrupted or otherwise inaccessible database files. You can use the demo version to test the recoverability of your databases.
Before I download the demo, how does it work? Is it as powerful as the full version of Recovery for SQL Anywhere?
The demo is almost the same as the full version, but with a limit on the number of recoverable rows in each SQL Anywhere table. This is a short limit, intended to show that the software is capable of recovering usable information.
After the data recovery program exceeds the set limit, it will populate all of the remaining rows in the SQL Anywhere database with “demo” placeholder text or null values, depending on the type of field targeted. As a result, the demo output is much smaller than a typical SQL Anywhere database file. In order to access the areas with the placeholders, you will need to purchase the full version of SQL Anywhere.
Where can I read about the differences in product license options?
Our Licensing page contains this information. Please review your options before purchasing.
Running the Recovery for SQL Anywhere software creates a folder with SQL scripts. There is also a batch file. How do I use these files?
You will need to recreate your database, either by manually processing the scripts in the folder or by simply running the batch file. Both options will recreate your database from scratch.
If you process the SQL scripts manually, you will need to process them in the appropriate order. Start with schema.sql, then process dataNNNN.sql.
I recovered my SQL Anywhere databases using the application, but the recovered files are smaller than my original files.
This can occur when damaged areas are nullified, and it is a common part of the data recovery process. Minor differences in file size should not cause any accessibility issues, although if your database is partially overwritten or permanently damaged, some features may not be available in the recovered database.
I have an Enterprise or Service software license. How do I operate Recovery for SQL Anywhere through the command line?
The command line is accessible through the Windows -> Run menu. Use the call format listed here:
sar.exe “”
You should not use angle brackets, and you should verify that you have created the directory for the recovered databases. If you need to use modifiers, use a question mark as a replacement for a single/individual symbol and use an asterisk for groups of symbols. By accessing the command line version of Recovery for SQL Anywhere, you can create batch files to carry out advanced processes, but remember to back up your original files before attempting recovery.