--- In firebird-support@yahoogroups.com, Thomas Steinmaurer <ts@...> wrote:

>
> > --- 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.
>
> Not that I know. Imagine if there is load on the database and the change
> timestamp gets automatically refreshed every time ...
>

Was hoping to be able to trick the system to update each time a user logged on (by changing metadata or something).

> What are you using for creating your incremental backups?

This is at a client site and I don't know what software they are using to do their incremental backups on their network. My opinion was that they should maybe change their incremental backups to include the database files each time regardless of the Date Modified. He said that was an option, but he would need to add an additional job to do this.

Maybe with the possibility of corruption, I should tell him to exclude the database files from backup entirely and only backup the gbk files that are created in the evening.

What are your thoughts on the corruption possibilities of the networks incremental backups?

Todd

>
> Regards,
> Thomas
>
> > Todd
> >
> >> --
> >> With regards,
> >> Thomas Steinmaurer (^TS^)
> >> Firebird Technology Evangelist
> >>
> >> http://www.upscene.com/
> >> http://www.firebirdsql.org/en/firebird-foundation/
> >>
> >
> >
> >
> >
> > ------------------------------------
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Visit http://www.firebirdsql.org and click the Resources item
> > on the main (top) menu. Try Knowledgebase and FAQ links !
> >
> > Also search the knowledgebases at http://www.ibphoenix.com
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > Yahoo! Groups Links
> >
> >
> >
>