Hi,

you could be happy the database was missed, because one of the few things to create a defect firebird database is copying the database while it has active connections.

I use GBAK to create automated backups of my databases every night. You can do that with a live database and even with connected users, it simply creates a "snapshot" of the state of the database at the moment you start GBAK.

I run it on windows and simply have a number of scheduled tasks to do the backup work.

Hope this helps.

Benno

----- Original Message -----
From: todderamaa
To: firebird-support@yahoogroups.com
Sent: Wednesday, February 29, 2012 8:21 PM
Subject: [firebird-support] Re: Timestamp of Database File





--- In firebird-support@yahoogroups.com, Thomas Steinmaurer <ts@...> wrote:
>
> > I just did a test in our environment. I logged into the database and made a change. The date modified on the database file wasn't updated. But when I logged out of the database, the date modified was updated. I was the only one logged into the database at the time.
> >
> > I logged into a client site where many users are connected to the database. I made a change in the data, but when I logged out, the date modified on the database file was not changed.
> >
> > Does it have something to do with the last person having to log out of the database?
>
> Yes. The timestamp changes when the last connection disconnects.
>
>

Is there anyway around this? The client runs incremental backups on their server 3 times a day. The database is getting missed because people stay logged into the database.

I was wondering if there was something we could do to the database in our application that would result in the Date Modified to be updated.

Todd

> --
> With regards,
> Thomas Steinmaurer (^TS^)
> Firebird Technology Evangelist
>
> http://www.upscene.com/
> http://www.firebirdsql.org/en/firebird-foundation/
>





[Non-text portions of this message have been removed]