We found it the ibo components was set to forced write no and that was causing the problem.
Thanks --- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote: > > At 08:55 a.m. 18/07/2013, rddymanohar wrote: > >Hi, > >We are on Firebird 1.56 and recently encountered database corruption problem > >with a customer. Found that forced write was turned off on the database and > >after the database was restored turned it on. However on checking the next > >day forced write was again turned off. We do daily sweep, reindex and backup > >on the database as maintenance at the the eod. Will any of this cause forced > >write to be turned off. > > None of the above will change the Forced Write setting. However, in the very > ancient version of Firebird that you are using, a client can do it, via the > connection API. The very first thing I would recommend is to examine closely > the connection settings on all client applications. > > A common source of this problem is Delphi applications that provide > properties and/or arrays of properties in the connection component > (connection alone, or database component). If this is your case, look at > *both* the property in question (ForcedWrites TRUE/FALSE) and *also* the > Params property of the connection/database component. > > > Helen Borrie, Support Consultant, IBPhoenix (Pacific) > Author of "The Firebird Book" and "The Firebird Book Second Edition" > http://www.firebird-books.net > __________________________________________________________________ >