Subject Re: [firebird-support] Newbies queries on type of data files and recovery options
Author Alexey Kovyazin
Hello,


>
> > 3. What are the common scenarios of a Firebird data file getting
> corrupt? In case of a single-file structure, I guess no other files
> need to be backed up?
>

There are some articles on our site

Firebird and InterBase corruptions reasons
http://www.ib-aid.com/articles/item70

Common InterBase/Firebird errors caused by corruptions and their
recovery chances
http://www.ib-aid.com/articles/item69
and ppt Firebird Anti-corruption approach
http://www.slideshare.net/ibsurgeon/firebird-anticorruption-approach

> In over ten years the only corruptions I've seen were due to
>
> 1) Full hard disk: IIRC in this case Firebird will overwrite the file
> from the beginning. Not good, but checking for free space on every
> write would slow down writes too much. Just make sure you have enough
> space.
>

This is far from true. Overwriting was an issue in Interbase 5.x.
Lack of free space was solved with pre-allocation in recent Firebird
versions - it will raise non-critical error.


Regards,
Alexey Kovyazin
IBSurgeon


[Non-text portions of this message have been removed]