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]
