IBSurgeon FirstAID is the tool that can automatically diagnose and repair corrupted InterBase or Firebird databases - it can repair corruptions that neither gbak nor gfix can handle.
It uses its own layer for low-level database access without using the InterBase or Firebird engine, so it can perform real "surgical" operations and repair your database when all other standard mechanisms cannot.
Now you are in 5 minutes from the recovery of your corrupted Firebird or InterBase database:
Usually database corruption means that some links between internal structures of Firebird (or InterBase) database are broken. When database engine sees a broken reference to missed record or database page, it stops operations with message like this:Internal gds software consistency check (here are details)
The first part of this error is a common prefix for bugcheck (i.e., serious error), and in the parentheses, there are details of the error.
Usually such error prevents normal work with the database, and recovery procedure should be executed. If it was not possible to fix corrupted Firebird (or InterBase) database with standard means (gfix.exe and gbak.exe), it is time for IBSurgeon FirstAID.
IBSurgeon FirstAID is designed to work with the database directly, on very low-level – it allows bypassing erroneous places where engine crashes and either fix broken links or export all users data to the new database.
There are 2 modules in FirstAID: FirstAID Direct and FirstAID Extractor. FirstAID Direct fixes corruption in place: it deletes or recreates missed links. This is very fast and efficient method: after fixing broken links database usually becomes readable, and it is possible to perform backup and restore. There are detailed instructions in FirstAID Recovery Guide how to use Direct module of FirstAID and perform final steps with gfix and gbak tools.
Unfortunately, FirstAID Direct cannot fix corruptions with massive metadata losses: in this case, FirstAID Extractor is required. FirstAID Extractor uses only few system tables to decrypt users data and export all available data to the new database.
Important! You can download the free version of FirstAID, open the corrupted database in Extractor and preview all available data – and if you can see these data, they can be saved and exported to the new empty database. FirstAID Extractor scans corrupted database, then shows list of tables, so user can browse them.
With IBSurgeon FirstAID it is possible to repair corrupted databases in more than 95% cases.
Important! If you cannot see data with FirstAID Extractor in your corrupted database, please contact our support: [email protected]. Please send diagnostic log and relevant details (full error text, screenshots, etc) to our support, and get recovery estimation for free.
You will receive an exact free answer on whether your database recoverable or not, is it recoverable by FirstAID directly, or some manual work needed. We will also try to estimate how much of your data can be recovered if there really is a serious problem that will not allow 100% recovery.
For serious problems we offer Firebird (and InterBase) database recovery service - see more details here.
FirstAID is licensed per database – “database” means database file which can be recovered. Most popular license is for 3 databases, it is enough for majority of clients.
If you are ISV (Independent Software Vendor, i.e., your company produces business software which uses Firebird or InterBase) or you have many databases, 50 databases license should be a perfect choice.
For those who need the complete recovery solution, there is HQBird Professional – it includes FirstAID for 50 databases, IBBackupSurgeon for recovering corrupted backups and IBUndelete to undelete occasionally deleted records.
HQbird Enterprise is our flagship product, it includes the following features: high availability and replication, recovery toolset for 100 databases, GUI for database development, backups' automation, transaction and queries monitoring, database structure analysis, optimized configurations and more.
Also it is possible to buy the upgrade for 5 and 50 databases. Upgrade can be done for any version of FirstAID or any previous Pack.
For large ISV companies we have very special offer – HQbird Professional Subscription for €499/month. This is an ultimate choice for serious companies which need a full set of recovery, monitoring and optimization tools for Firebird: such subscription allows an unlimited usage of HQbird Professional for business applications (ERP, CRM, etc) during the period of subscription.
Don't hesitate to contact us to discuss licensing options!
|FirstAID for 3 databases||Recovery tool. License to recover 3 Firebird or InterBase databases.||€189||$199|
|FirstAID for 50 databases||Recovery tool. License to recover 50 Firebird or InterBase databases.||€359||$399|
|HQbird: advanced Firebird distribution|
|HQbird Professional||HQbird Professional includes the following features: recovery toolset (FirstAID and other recovery tools for 50 databases), GUI for database development, backups' automation, transaction and queries monitoring, database structure analysis, optimized configurations.||€599|
|HQbird Enterprise||HQbird Enterprise includes the following features: high availability and replication, recovery toolset, GUI for database development, backups' automation, transaction and queries monitoring, database structure analysis, optimized configurations and performance self-test.||€799|
|ISV SUBSCRIPTIONS - MONTHLY|
|HQbird Professional ISV Subscription||Unlimited usage of HQbird Professional for business applications.||€499/month|
|Upgrade FirstAID for 5 databases||It adds 5 databases to FirstAID 3.7, or any version of FirstAID (standalone or included in Pack, including old versions 1.x-3.x)||€99||$129|
|Upgrade FirstAID for 50 databases||It adds 50 databases to FirstAID 3.7, or any version of FirstAID (standalone or included in Pack, including old versions 1.x-3.x)||€199||$269|
There is a number of possible corruptions that IBSurgeon FirstAID has been designed to repair and correct. These are listed below:
For those who don't want to experience a corruption again, we recommend HQbird Enterprise, with the option to create a mirror (warm-standby) for the database or even fail-safe cluster.