--- In firebird-support@yahoogroups.com, "Ann W. Harrison" <aharrison@...> wrote:

>
> On 9/20/2010 1:12 PM, majstor wrote:
> > Hi Ann& emb_blaster
> >
> > Changes are committed because those changes are valid for few days, and after that the changes are returned to old values. Between that some machines are power off every night at the end of work time. Software use same procedure, same logic and same client application for all of 3 database systems and just firebird work like this :-(
> > System restore is turned off on all of my installed systems!
> >
> > Where can be the problem if the sweep isn't?
> >
> >>
> >> ... or, if are windows machines, maybe you are using GDB extension with System Restore activated.
> >>
>
> Check the creation dates, last modified dates, and file sizes. It
> sounds as if something on the system is reverting the Firebird
> database to an earlier version. There is nothing in Firebird that
> removes current versions and replaces them with old ones.
>
>
> Good luck,
>
> Ann
>

Ok, I'll made one procedure which will clear database in time where users are not at work. I have some database which is used 24h and I need call sweep to those databases.

Which of gfix option is recomended to use for that cleaning procedure before backup database in work time and for database in sleep time.

Thanks again...