Subject RE: [firebird-support] Re: Timestamp of Database File
Author Jerry Sands
Do a database backup just before the incremental backup and that backup file
will get backed up. The incremental backup of the database may not be any
good if there are connections to the database.





From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of todderamaa
Sent: Wednesday, February 29, 2012 1:22 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Timestamp of Database File







--- In firebird-support@yahoogroups.com
<mailto:firebird-support%40yahoogroups.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]