Subject Re[5]: [firebird-support] Broken databases
Author Dmitry Kuzmenko
Hello, Dmitri!

Monday, November 18, 2013, 10:25:37 AM, you wrote:

DM> I try restore broken backup, a lot of errors in firebird.log like
DM> this. So a lot of trigger Check_X is broken, when I repair DB, I
DM> also delete them when repairing structure of DB.

DM> Server (Server)Mon Nov 18 10:10:27 2013
DM> Database: C:\DATABASE\ERRORDB\MAINBASE.FDB
DM> RDB$FLAGS for trigger CHECK_2791 in RDB$TRIGGERS is corrupted (304)

This is ... useless. Since metadata is broken, the only way to get
correct DB is to pump data from broken DB to a new, clean DB.

Al that you said about DB defects, can be caused by
- bad RAM
- updating metadata while working with data. 2.5 is more stable in
that situations, but I think there is still some problems can hide.
Do your application allow to change metadata? How often?

--
Dmitry Kuzmenko, www.ib-aid.com