Dear sirs,
At our company, we use a copy of the production db as development db, for many
reasons.
When we do that, we make a phisycal copy of the fdb file.
We observed that, when we make this copy, the generators are not updated, what
forces us to update manually the development
Never copy the FDB file! You WILL corrupt both FDB and copy file!
The best approach is do a gbak to backup and then restore the FDB.
You MUST read the firebird FAQ here: http://www.firebirdfaq.org/
Also: http://www.firebirdsql.org/manual/qsg10-howtocorrupt.html
and
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
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
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
Also: google for “How to corrupt a Firebird database”. Even Anti Virus programs
can (rarely) corrupt a database.
Fabiano
[Non-text portions of this message have been removed]
: [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
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
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.
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
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
?
--- 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
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
.
--- 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
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:
:
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
16 matches
Mail list logo