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: [email protected] Sent: Wednesday, February 29, 2012 8:21 PM Subject: [firebird-support] Re: Timestamp of Database File --- In [email protected], 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]
