IBSurgeon

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
     
This Site Uses:

IBFirstAid V2.0

What’s new in IBFirstAID V2.0?

IBFirstAID now comes in two versions, one for Firebird and one for InterBase. This has been done because the mechanism's used to repair the two databases, although similiar have become different over time.

List of new features:

  • Firebird V2.0.x support.
  • InterBase V7.5.x - 2007 support (including record formats).
  • Analysis and estimation of the ability to do an automatic repair.
  • Command line mode (for diagnostics only).
  • Improved algorithm's for fixing corrupted record backversions and fragments.
  • Ability to fix InterBase V7.5. "Stack overflow error" on opening a database.
  • Improved algorithm's for fixing BLOB errors.
  • Opening a database, checking a database an doing the repair is much faster.
  • Improved user interface and usability, different dialogs for single and multi-volume databases.

IBFirstAID is a tool that can automatically diagnose and repair corrupted Firebird or InterBase databases.

Two versions of IBFirstAID are available as free downloads:

A free version that is downloadable allows you to diagnose potential problems with your database and there is also a commercial version that allows you to fix the problems that are found. The diagnostic features allow you to check a database's validity. Whilst the fully featured version is capable of fixing a number of common database corruption problems.

IBFirstAID uses its own database access layer to connect to analyze and repair a Firebird or InterBase database.

There are a number of possible corruptions that IBFirstAID has been designed to repair and correct. These are listed below:

  • Internal gds software consistency check (cannot find tip page (165))
    The required Transaction Inventory Page is corrupt and the database cannot be opened. It is expected in this instance that neither gbak nor gfix will be able to repair your database (except in the case of a Read Only database). IBFirstAID will repair the missing pages and recover the database.
  • Unknown database I/O error for file "*.gdb"
    Error while trying to read from the database file. This usually indicates that a number of database pages have probably been lost at the end of the database file (power failure?). In this instance the database cannot be opened. Gfix cannot repair this. IBFirstAID will recreate the missing system pages and deletes the wrong pointers.
  • Database file appears corrupt. Wrong page type. Page NNN is of wrong type (expected X, found Y)
    This error can indicate a number of problems. But typically there are missing pages in the database, or the page that is being accessed is not the expected page type. For example, if the expected page type is 5, it can mean that some data may have been corrupted within a table. Such a corruption may prevent a sucessful backup backup or may make the table unavailable to the database.
    IBFirstAID fixes the wrong page pointers and repairs the database.
  • Wrong record length. Cannot find backversion.
    IBFirstAID will check every record in database and will try and repair these record-level errors.
  • Other database corruptions can be caused by lost pages.

Product Properties

IBFirstAID is the only solution for automatically repairing corruption that neither gbak nor gfix can handle. IBFirstAID 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 mechanism's cannot.

Using IBFirstAID together with other standard recovery means such as the default gfix and gbak utilities it is possible to repair a corrupted database in more than 80% of all cases.

IBSurgeon has a free Diagnostic version of IBFirstAID which you can use to accurately check the actual database status. It will analyze the low-level data structures in your database and present you with a detailed log of what may be wrong in the database.

You can send the diagnostic log to our support service for a free answer on whether your database recoverable or not, whether its recoverable by IBFirstAid directly, or whether we need to perform some manual work to assist the recovery process. We will also try and estimate how much of the your data can be recovered if there really is a serious problem that will not allow 100% recovery.

White Papers

  • Diagnosing and Repairing Database Corruption
  • Firebird and InterBase Errors and Problems
  • Licensing

    IBFirstAID Personal for Firebird is used to repair databases that are used within a single company.
    Price: $299.00 Shop{short description of image}

    IBFirstAID Personal for InterBase is used to repair databases that are used within a single company.
    Price: $299.00 Shop{short description of image}

    IBFirstAID Site License is used to repair databases if you distribute Firebird or InterBase with your software
    Price: $799.00 Shop{short description of image}

    IBFirstAID Vendor License allows you to include and distribute IBFirstAID with your own software.
    Pricing is negotiable
    Please contact Paul Beach to discuss further details.

    Note: If you wish to use IBFirstAid to try and mend databases used by your customers then you must buy at least the IBFirstAid Site version. The Personal version is designed for internal company use only.

    Download

    The latest version of IBFirstAID Diagnostician is available for download.

    If IBFirstAid cannot help you with your problem, then contact us and we will try and repair your database under the following terms.

    Price: $390.00/2 hours, 2 hours minimum. Then $195.00 per hour until the repair is completed.