Monday, December 24, 2012

Why Interbase Database Get Corrupt & How to repair it?

InterBase is a relational database management system & can be run on the many operating systems such as Linux, Microsoft Windows, Mac OS X and Solaris. In Interbase database, corruption does occur due to many causes but  it is very important to find the exact cause of the corruption otherwise you can loose your data. 

Here are some known causes of InterBase database corruption:

  • Shutting off the power on the server due electrical power interruption cause to database corruption. To avoid this cause, there is a necessity of having a source of uninterrupted power supply on your server. 
  • Copy database file or other file access to the database when the server is running. 
  • When the Database files become too large. For UNIX platform servers the limit is 2 GB, for Windows NT/2000 - 4 GB. 
  • If the server got crash while writing to disk, in this case the database may get corrupted.
  • Connecting to database during the database restoration process. 
  • When you try to move InterBase database from one OS to another by copying the database files. It can also lead to database corruption. 
  • If the client and server versions are not same then in this case the server get crash. Due to Server Crash your database got corrupted. 

Prevent Interbase database corruption: One of most trusted method to prevent database corruption is regularly update your backup. 

Repair corrupt Interbase Database: To repair your corrupt database, you can use command-line utility  -gfix or Database Validation in IBConsole.

GFIX has the following syntax:
Gfix [ options] db_name 

Final Words: If you want that your database never get corrupt then you should run database Validation or command-line 'gfix' from time to time. if the database corruption does occur so you can easily handle it before the severe damage to database & it is too easy to repair.

No comments:

Post a Comment