| Subject | Re: [IBO] Migration to IBO 4.9/DXE2 changes db file behavior |
|---|---|
| Author | ifitsx |
| Post date | 2012-02-06T19:24:24Z |
--- In IBObjects@yahoogroups.com, "IBO Support List" <supportlist@...> wrote:
As I read Chapter 38, p.813, of The Firebird Book, 1st ed. which states that "Do not rely on backups of your Firebird databases made by ... filesystem copy utilities, or compression utilities... <i>unless the database is completely shut down.<i>
The phrase "unless the database is completely shut down" means to me that making a backup copy or compressed archive of the database when it is shutdown will result in a reliable backup.
I have used the Firebird backups made by AJC Active Backup and they have always resulted in a reliable return of my data.
Now, my original question is still open: is there something about the combination of "IBO4_9_14_b36i/DXE2/sp3/Win7 x64" which is changing the database's date/time upon opening that can be altered to stop this and return it to its original behavior where the database's date/time is not changed until the database is closed.
Barry
>Jason, I appreciate your concern. However, I believe I have always clearly understood these issues as long as the info in The Firebird Book is accurate: my Firebird database files have never been backed up while they are open unless with gbak.
> You should NOT have that file being backed up directly. You should only
> archive a file created as a result of a gbak operation to create a backup
> file.
>
> Jason
As I read Chapter 38, p.813, of The Firebird Book, 1st ed. which states that "Do not rely on backups of your Firebird databases made by ... filesystem copy utilities, or compression utilities... <i>unless the database is completely shut down.<i>
The phrase "unless the database is completely shut down" means to me that making a backup copy or compressed archive of the database when it is shutdown will result in a reliable backup.
I have used the Firebird backups made by AJC Active Backup and they have always resulted in a reliable return of my data.
Now, my original question is still open: is there something about the combination of "IBO4_9_14_b36i/DXE2/sp3/Win7 x64" which is changing the database's date/time upon opening that can be altered to stop this and return it to its original behavior where the database's date/time is not changed until the database is closed.
Barry
> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
> Of ifitsx
> Sent: 06 February 2012 09:30 AM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] Migration to IBO 4.9/DXE2 changes db file behavior
>
> New system: IBO4_9_14_b36i/DXE2/sp3/Win7 x64
> Old system: IBO4_2Hd/D7/Win2k/sp4
>
> Using just IBODatabase and IBOQuery.
>
> I have discovered that an app which uses IBObjects/Firebird and has been
> migrated to DXE2 changes its file date/time as soon as it is opened,
> whereas, my other app, still under IBO4_2Hd/D7, when opened still has its
> file date/time listed for when it was closed the previous evening. (Both are
> now running on Win7 x64.)
>
> This change in behavior is interfering with AJC Active Backup, my file
> archiving/backup app, which has a color coded icon in the tray: When it is
> open and active but not archiving anything, it is green; when it is
> archiving something it turns yellow; when it is open, but turned off the
> icon is red.
>
> So, with this change in behavior, I don't have the opportunity to actively
> monitor that my other files are being archived, because as soon as I open
> the app migrated to IBO4_9x/DXE2, the AJC icon turns yellow and stays that
> way all day until I close the app.
>
> If there is something IBO related that I can do to change this behavior -
> stop the database file's date/time from being changed when the db is opened
> - I'd be grateful to know what I might do.
>
> Barry
>