Subject Re: [firebird-support] DB modified date is over a month old, but Forced Writes are ON??
Author Woody
From: "rjschappe" <rschappe@...>

> I have recently been made aware that a client's firebird 1.5 database has
> not been backed up for over a month!
>
> Firebird 1.5 DBMS was installed on a Win 2003 server and when I remotely
> logged in, I noticed that the "Modified Date" was over a month old.
>
> That is weird, since this is their main corporate database and they use it
> every day.
>
> I thought that maybe someone had turned Forced Writes to OFF but I just
> checked the properties and it says that Forced Writes are ON.
>
> I need to back this up... but now I am very frightened that if I go about
> this incorrectly, I may lose over a month's worth of production data.
>

Ray,

Not 100% sure, but the modified date won't change until it is completed
disengaged from by FB. If any user stays logged in, even though the database
is updated, the system won't change the modified date since it can't
finalize (close) it, or something like that. That's what I've noticed on
most Windows systems anyway.

Backing the database up shouldn't be a problem since it doesn't require
exclusive access.

Woody (TMW)