Subject | Re: Copying DB |
---|---|
Author | Adam |
Post date | 2008-11-05T03:59:59Z |
--- In firebird-support@yahoogroups.com, Robert martin <rob@...> wrote:
valid file copy of an active database file unless you deny firebird
from writing to the file during the copy. Otherwise you will end up
with an inconsistent mish-mash of new and old data pages in your copy.
GBak pretty much does a select * from every table in your database and
writes it to another file. It is safe because it all happens within a
transaction context, so Firebird knows which records are too new for
gbak to need, and which deleted records it should pretend still exists.
What version of Firebird are you on? If you are on 2.x, you can look
at NBackup. That may do the trick.
Adam
>the DB
> Hi Ann
>
> I knew that, unfortunately I can guarantee other people are using
> (the multi threaded app that is doing the backup for one !). I wasI don't know how you think that might work. You can not just take a
> really wondering if there was a switch for Gbak that could be used to
> say, dont backup just copy or something else I hadn't thought of :)
>
valid file copy of an active database file unless you deny firebird
from writing to the file during the copy. Otherwise you will end up
with an inconsistent mish-mash of new and old data pages in your copy.
GBak pretty much does a select * from every table in your database and
writes it to another file. It is safe because it all happens within a
transaction context, so Firebird knows which records are too new for
gbak to need, and which deleted records it should pretend still exists.
What version of Firebird are you on? If you are on 2.x, you can look
at NBackup. That may do the trick.
Adam