Subject Re: [ib-support] database corruption after some number of changes
Author Svein Erling Tysvaer
I don't think this will corrupt your database, but there is a limit as to
how many metadata changes you can do before you need to backup/restore.
E.g. I think there was (I don't know if it has been changed, but assume so)
a limit of 255 changes on each object, meaning that you need to
backup/restore for every 127th time you turn your an index on/off.

The one way to easily corrupt a Firebird database is to run it on Windows
with forced writes off. I think corruption also occurs if you run out of
space on your hard disk.

Tell us a bit more about what your procedure does, how often you run it and
why you run it. Then, we will be able to help you more.



- I support Firebird, I am a FirebirdSQL Foundation member.
- Join today at