[firebird-support] Re: Timestamp of Database File

2012-03-02 Thread todderamaa
--- In firebird-support@yahoogroups.com, Thomas Steinmaurer ts@... wrote: --- In firebird-support@yahoogroups.com, Thomas Steinmaurerts@ wrote: --- In firebird-support@yahoogroups.com, Doug Chamberlinchamberlin.doug@ wrote: On 2/29/12 2:50 PM, todderamaa wrote: Maybe with the

Re: [firebird-support] Re: Timestamp of Database File

2012-03-02 Thread Thomas Steinmaurer
Hi Todd, --- In firebird-support@yahoogroups.com, Thomas Steinmaurerts@... wrote: --- In firebird-support@yahoogroups.com, Thomas Steinmaurerts@ wrote: --- In firebird-support@yahoogroups.com, Doug Chamberlinchamberlin.doug@wrote: On 2/29/12 2:50 PM, todderamaa wrote: Maybe with

Re: [firebird-support] Re: Timestamp of Database File

2012-03-01 Thread Ann Harrison
Probably beating a dead horse, but ... On Wed, Feb 29, 2012 at 2:44 PM, todderamaa toddera...@yahoo.com wrote: I have heard that you can corrupt a database when copying it with active connections. I am wondering if incremental windows backups are different than a 'copy'. You may have heard

RE: [firebird-support] Re: Timestamp of Database File

2012-03-01 Thread bogdan
We are working with large (5-30 GB) Firebird (2.x) databases. There were some occasions where when copying even the original became currupted. Not often but still - we haven't documented it. Lately we don't encounter such problems - as you securely understand - man get used to automatically

Re: [firebird-support] Re: Timestamp of Database File

2012-02-29 Thread Thomas Steinmaurer
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

[firebird-support] Re: Timestamp of Database File

2012-02-29 Thread todderamaa
--- 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.

RE: [firebird-support] Re: Timestamp of Database File

2012-02-29 Thread Jerry Sands
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

Re: [firebird-support] Re: Timestamp of Database File

2012-02-29 Thread Thomas Steinmaurer
--- In firebird-support@yahoogroups.com, Thomas Steinmaurerts@... 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

Re: [firebird-support] Re: Timestamp of Database File

2012-02-29 Thread Benno
@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

[firebird-support] Re: Timestamp of Database File

2012-02-29 Thread todderamaa
. 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

[firebird-support] Re: Timestamp of Database File

2012-02-29 Thread todderamaa
--- In firebird-support@yahoogroups.com, Thomas Steinmaurer ts@... wrote: --- In firebird-support@yahoogroups.com, Thomas Steinmaurerts@ 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.

Re: [firebird-support] Re: Timestamp of Database File

2012-02-29 Thread Lester Caine
todderamaa wrote: We just had an issue at a site and the client was thinking they could use their Incremental Backups on their network to solve the issue. They were surprised to see that the database was being missed This is why I posted to find a solution. I think that probably answers

Re: [firebird-support] Re: Timestamp of Database File

2012-02-29 Thread Doug Chamberlin
On 2/29/12 2:50 PM, todderamaa wrote: 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. This is the usual way to backup Firebird databases in situations like your clients

[firebird-support] Re: Timestamp of Database File

2012-02-29 Thread todderamaa
--- In firebird-support@yahoogroups.com, Doug Chamberlin chamberlin.doug@... wrote: On 2/29/12 2:50 PM, todderamaa wrote: 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

RE: [firebird-support] Re: Timestamp of Database File

2012-02-29 Thread Leyne, Sean
Doug, On 2/29/12 2:50 PM, todderamaa wrote: 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. This is the usual way to backup Firebird databases in situations like

Re: [firebird-support] Re: Timestamp of Database File

2012-02-29 Thread Doug Chamberlin
On 2/29/12 3:30 PM, todderamaa wrote: --- In firebird-support@yahoogroups.com, Doug Chamberlin chamberlin.doug@... wrote: On 2/29/12 2:50 PM, todderamaa wrote: Maybe with the possibility of corruption, I should tell him to exclude the database files from backup entirely and only backup the

Re: [firebird-support] Re: Timestamp of Database File

2012-02-29 Thread Doug Chamberlin
On 2/29/12 3:28 PM, todderamaa wrote: But with this latest issue, we needed the database file and not the backup. The restore of the backup failed, because we had a stored procedure that was selectable that didn't include a 'suspend' statement. I think this must be something that was allowed

RE: [firebird-support] Re: Timestamp of Database File

2012-02-29 Thread Leyne, Sean
Doug, If Firebird's' classic architecture is being used then each process accessing the file can read it. However, it's hard to imagine a read-only file access would corrupt the file being read. Perhaps better experts than I can give you a more definitive answer. We have over 100

Re: [firebird-support] Re: Timestamp of Database File

2012-02-29 Thread Doug Chamberlin
On 2/29/12 3:47 PM, Leyne, Sean wrote: The NBackup functionality allows a database file to be quiesced (with changes written to a delta file) to allow for OS level backups to be performed (thru Lock and Unlock options). But doesn't that just move the potential conflict to the delta file,

Re: [firebird-support] Re: Timestamp of Database File

2012-02-29 Thread Kjell Rilbe
Den 2012-02-29 22:22 skrev Doug Chamberlin såhär: On 2/29/12 3:47 PM, Leyne, Sean wrote: The NBackup functionality allows a database file to be quiesced (with changes written to a delta file) to allow for OS level backups to be performed (thru Lock and Unlock options). But doesn't that

RE: [firebird-support] Re: Timestamp of Database File - Email found in subject

2012-02-29 Thread Leyne, Sean
Doug, The NBackup functionality allows a database file to be quiesced (with changes written to a delta file) to allow for OS level backups to be performed (thru Lock and Unlock options). But doesn't that just move the potential conflict to the delta file, leaving you with the same issue

RE: [firebird-support] Re: Timestamp of Database File

2012-02-29 Thread Leyne, Sean
Kjell, I did have some issue with it 1-2 years ago, with a rather large DB. Some problem with transaction commit during nbackup locked state. I never had time to investigate if it was really caused by nbackup, but it only happened in that state... A review of the project tracker finds that

Re: [firebird-support] Re: Timestamp of Database File

2012-02-29 Thread Thomas Steinmaurer
Sean, I did have some issue with it 1-2 years ago, with a rather large DB. Some problem with transaction commit during nbackup locked state. I never had time to investigate if it was really caused by nbackup, but it only happened in that state... A review of the project tracker finds that

RE: [firebird-support] Re: Timestamp of Database File

2012-02-29 Thread Leyne, Sean
Thomas, To quote Dmitry from a few weeks ago (around mid Jan. 2012), the usage of nbackup in 2.1 with Classic under high load can be problematic. It seems that there was quite a re-write in 2.5 though. I believe that his comment was related to the use in creating backup, not in locking the

Re: [firebird-support] Re: Timestamp of Database File

2012-02-29 Thread Thomas Steinmaurer
Sean, To quote Dmitry from a few weeks ago (around mid Jan. 2012), the usage of nbackup in 2.1 with Classic under high load can be problematic. It seems that there was quite a re-write in 2.5 though. I believe that his comment was related to the use in creating backup, not in locking the

[firebird-support] Re: Timestamp of Database File

2012-02-29 Thread todderamaa
--- In firebird-support@yahoogroups.com, Thomas Steinmaurer ts@... wrote: --- In firebird-support@yahoogroups.com, Doug Chamberlinchamberlin.doug@ wrote: On 2/29/12 2:50 PM, todderamaa wrote: Maybe with the possibility of corruption, I should tell him to exclude the database files

Re: [firebird-support] Re: Timestamp of Database File

2012-02-29 Thread Thomas Steinmaurer
--- In firebird-support@yahoogroups.com, Thomas Steinmaurerts@... wrote: --- In firebird-support@yahoogroups.com, Doug Chamberlinchamberlin.doug@ wrote: On 2/29/12 2:50 PM, todderamaa wrote: Maybe with the possibility of corruption, I should tell him to exclude the database files from