Re: RES: [firebird-support] Copy of the current db not updating generators

2012-05-31 Thread Mark Rotteveel
On Thu, 31 May 2012 13:23:55 +0200, Kjell Rilbe kjell.ri...@datadia.se wrote: Den 2012-05-31 13:19 skrev Mark Rotteveel såhär: On Thu, 31 May 2012 08:09:33 -0300, Fabiano fabianoas...@gmail.com mailto:fabianoaspro%40gmail.com wrote: Never copy the FDB file! You WILL corrupt both FDB and

RE: RES: [firebird-support] Copy of the current db not updating generators

2012-05-31 Thread bogdan
Although I agree with your advice, in general copying the file can corrupt the target file, but it cannot corrupt not the source file. Usually for copying a file the copy program will acquire a read lock, so nothing is changed and the database process can continue writing to the file without

Re: RES: [firebird-support] Copy of the current db not updating generators

2012-05-31 Thread Mark Rotteveel
On Thu, 31 May 2012 04:25:02 -0700 (PDT), Tupy... nambá anhangu...@yahoo.com wrote: Ok, thanks. This is well known.   Then I ask = restoring the db will put the generators in the updated status ?  I am not sure what the problem is your having. Making a backup of production and restoring it in

Re: RES: [firebird-support] Copy of the current db not updating generators

2012-05-31 Thread Tupy . . . nambá
: [firebird-support] Copy of the current db not updating generators To: firebird-support@yahoogroups.com Date: Thursday, May 31, 2012, 4:10 PM On Thu, 31 May 2012 04:25:02 -0700 (PDT), Tupy... nambá anhangu...@yahoo.com wrote: Ok, thanks. This is well known.   Then I ask = restoring the db

Re: RES: [firebird-support] Copy of the current db not updating generators

2012-05-31 Thread Hannes Streicher
Hello Tupy... nambá, what is the setting of forced writes because generators are outside of transaction control and thf shud be updated immediately Thanks, Mark. This is exactly what I needed to know.   We know about the risks making copies this way, but this is done by another person, not

Re: RES: [firebird-support] Copy of the current db not updating generators

2012-05-31 Thread Ann Harrison
On Thu, May 31, 2012 at 8:29 AM, Hannes Streicher hstreic...@gmx.de wrote: Hello Tupy... nambá, what is the setting of forced writes because generators are outside of transaction control and thf shud be updated immediately Generators are not written to disk every time they're changed.

RE: RES: [firebird-support] Copy of the current db not updating generators

2012-05-31 Thread Tupy . . . nambá
Alan,   yes, FORCED WRITES is checked.     --- On Thu, 5/31/12, Alan McDonald a...@meta.com.au wrote: From: Alan McDonald a...@meta.com.au Subject: RE: RES: [firebird-support] Copy of the current db not updating generators To: firebird-support@yahoogroups.com Date: Thursday, May 31, 2012, 4:26

Re: RES: [firebird-support] Copy of the current db not updating generators

2012-05-31 Thread Tupy . . . nambá
Rotteveel m...@lawinegevaar.nl Subject: Re: RES: [firebird-support] Copy of the current db not updating generators To: firebird-support@yahoogroups.com Date: Thursday, May 31, 2012, 4:56 PM On Thu, 31 May 2012 14:29:41 +0200, Hannes Streicher hstreic...@gmx.de wrote: Hello Tupy... nambá, what

Fw: Re: RES: [firebird-support] Copy of the current db not updating generators

2012-05-31 Thread Tupy . . . nambá
? --- On Thu, 5/31/12, Mark Rotteveel m...@lawinegevaar.nl wrote: From: Mark Rotteveel m...@lawinegevaar.nl Subject: Re: RES: [firebird-support] Copy of the current db not updating generators To: firebird-support@yahoogroups.com Date: Thursday, May 31, 2012, 4:56 PM On Thu, 31 May 2012 14:29:41

Re: Fw: Re: RES: [firebird-support] Copy of the current db not updating generators

2012-05-31 Thread Mark Rotteveel
On Thu, 31 May 2012 06:43:14 -0700 (PDT), Tupy... nambá anhangu...@yahoo.com wrote: Or, according to An Harrison´s explanation, the generators had not been updated due to not have been commited Even then, it would still show (older) values from production, not from your previous test

Re: Fw: Re: RES: [firebird-support] Copy of the current db not updating generators

2012-05-31 Thread Tupy . . . nambá
.  --- On Thu, 5/31/12, Mark Rotteveel m...@lawinegevaar.nl wrote: From: Mark Rotteveel m...@lawinegevaar.nl Subject: Re: Fw: Re: RES: [firebird-support] Copy of the current db not updating generators To: firebird-support@yahoogroups.com Date: Thursday, May 31, 2012, 5:51 PM On Thu, 31 May 2012

Re: RES: [firebird-support] Copy of the current db not updating generators

2012-05-31 Thread Norman Dunbar
Evening, On 31/05/12 13:21, Tupy... nambá wrote: We know about the risks making copies this way, but this is done by another person, not by ourselves. There is a recipe for using external (to Firebird supplied) tools to backup or copy a database here:

RE: Re: RES: [firebird-support] Copy of the current db not updating generators

2012-05-31 Thread Tupy . . . nambá
: From: bogdan bog...@mordicom.si Subject: RE: Re: RES: [firebird-support] Copy of the current db not updating generators To: firebird-support@yahoogroups.com Date: Thursday, May 31, 2012, 9:48 PM Sorry One can not just copy database and believe that everything will be allright