Thanks for that. Your correct. It seems I got excited did not check before handing over to Robert. I ran the test again and get the same error
[
PROBLEM ON "end backup".
unsuccessful metadata update
-Database is not in the physical backup mode
SQLCODE:-607
]

We'll continue investigating the cause of our slow down problem on this end.

Also Ann mentioned IBPhoenix. Do you know if anyone used IBreplicator for the purpose of running a gbak backup restore and replicating changes back to the new database?

Thanks,
David

--- In firebird-support@yahoogroups.com, "hvlad" <hvlad@...> wrote:
>
>
>
> --- In firebird-support@yahoogroups.com, "davidwilder_13" <davidwilder13@> wrote:
> >
> > Hi Ann,
> >
> > I work with Robert. We assumed this worked after running a quick test;
> > 1. Create test.fdb, create table and insert 2 records
> > 2. Lock database
> > #./nbackup -U BASX -P **** -L ../data/test.fdb
> > 3 Copy database to temp location
> > #cp ../data/test.fdb ../data/temp/test.fdb
> > 4. inserted a few more records into the original database which created a merge file
> > 5. Set state of backup database to normal with nbackup
> > #./nbackup -U BASX -P **** -F ../data/temp/test.fdb
> > 6. Backup and restore
> > #./gbak -b -t -v -user BASX -pas **** "../data/temp/test.fdb" "../data/temp/test.gbk"
> > #./gbak -c -p 16384 -v -user BASX -pas **** ../data/temp/test.gbk ../data/temp/testnew.gdb
> > 7. Then Shutdown service and swap the databases
> > #/etc/intit.d/firebird stop
> > #mv ../data/temp/testnew.gdb ../data/test.fdb
> > #/etc/intit.d/firebird start
> > 8. Then merge changes back in with nbackup
> > #./nbackup -U BASX -P **** -N ../data/test.fdb
>
> This step should fail as just restored database is not in stalled mode.
> You missed something. Or you found a bug (i don't think so).
>
> > After this we found the merge file was deleted and we had all 6 records in the new database.
>
> It is impossible.
>
> Regards,
> Vlad
>
> PS
>
> > 1. Create test.fdb, create table and insert 2 records
> ...\bin>isql
> Use CONNECT or CREATE DATABASE to specify a database
> SQL> create database 'test.fdb';
> SQL> create table t (id int);
> SQL> insert into t values(1);
> SQL> insert into t values(2);
> SQL> commit;
> SQL> exit;
>
> > 2. Lock database
> ...\bin>nbackup -L TEST.FDB
>
> > 3 Copy database to temp location
> ...\bin>copy TEST.FDB TEST_2.FDB
> 1 file(s) copied.
>
> > 4. inserted a few more records into the original database which created a merge file
> ...\bin>isql TEST.FDB
> Database: TEST.FDB
> SQL> insert into t values(10);
> SQL> insert into t values(11);
> SQL> insert into t values(12);
> SQL> insert into t values(13);
> SQL> commit;
> SQL> select * from t;
>
> ID
> ============
> 1
> 2
> 10
> 11
> 12
> 13
>
> SQL> exit;
>
> > 5. Set state of backup database to normal with nbackup
> ...\bin>nbackup -F TEST_2.FDB
>
> > 6. Backup and restore
> ...\bin>gbak -b TEST_2.FDB TEST_2.FBK
> ...\bin>gbak -r TEST_2.FBK TEST_3.FDB
>
> > 7. Then Shutdown service and swap the databases
> ...\bin>ren TEST.FDB TEST_0.FDB
> ...\bin>ren TEST_3.FDB TEST.FDB
>
> > 8. Then merge changes back in with nbackup
> ...\bin>nbackup -N TEST.FDB
> [
> PROBLEM ON "end backup".
> unsuccessful metadata update
> -Database is not in the physical backup mode
> SQLCODE:-607
> ]
> Failure: Database error
>