Subject | Re: [firebird-support] Newbies queries on type of data files and recovery options |
---|---|
Author | Alexey Kovyazin |
Post date | 2011-09-28T16:48:12Z |
Hello,
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
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]
>There are some articles on our site
> > 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?
>
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 toThis is far from true. Overwriting was an issue in Interbase 5.x.
>
> 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.
>
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]