Can Recovery for Interbase repair my Interbase / Firebird database?
The effective way to find out if a Interbase / Firebird database is recoverable is to try the demo version of Recovery for Interbase 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 Interbase / Firebird database before proceeding with any recovery activity!
What limitations does the demo version of Recovery for Interbase have?
The demo version recovers a limited number of rows in each table of the recovered database. The remaining rows will contain "demo" in text fields and null values in other types of fields.
No additional records or tables will be recovered by commercial version of Recovery for Interbase if not present in demo output.
I have tried the demo. How do I decide whether to purchase the full version of Recovery for Interbase?
Evaluating the results of demo recovery can help in making the decision.
What are the differences between product licenses?
Details of current licensing scheme are described at the Licensing page.
Why do results of recovery contain less data than the original Interbase / Firebird database?
This is normal. The damaged parts of your Interbase / Firebird database will convert to zero size on output. The other common reason of file size decrease is when some of features of the original database are not supported and therefore absent from the recovered database.
Demo-recovered database is smaller because it mostly consists of demo placeholders than actual data.
Running Recovery for Interbase from command line (through Windows Start -> Run menu).
If your license type is Enterprise or Service, you can run Recovery for Interbase 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:
ibr.exe <original filename with path> "<path to directory to store the recovered file(s)>"
(without angle brackets).
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).
After running Recovery for Interbase on the corrupted database, a folder with sql script(s) and batch file has been created. How could these files be transfigured into a new database?
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).
Processing of sql scripts created by Recovery for Interbase does not rebuild the database and/or produce any error messages. What is the problem with?
In addition to script(s) the assisting batch file runme.bat is created to automate database rebuilding procedure. Please, run this batch file passing a path to isql.exe utility as a command-line argument (e.g. runme.bat c:\Interbase\bin\).
Also note that a database administrator password is required to rebuild database. By default, it is set to "masterkey" in all SQL-scripts created during recovery process.
To start database rebuild procedure one of three possible alternatives is possible:
Replace manually the default Database Administrator (SYSDBA) password “masterkey” with the password required. The password should be replaced in every single script created during database recovery;
Change temporarily Database Administrator’s password to "masterkey" and after database recreation is complete change it back to the previous value;
Input the desired password in the Password field while selecting database to be recovered.