On 09/08/13 14:07, jack.mason58 wrote:

> Thanks for your response, but this doesn't appear to be relevant as we do not know what ODS is, have never used it, and created the database brand new under Firebird 2.5.

ODS is On Disc Structure. If you run a gstat -h database_name (or fbstat
-h database on Linux Mint!) then it will display something like the
following:

$ fbstat -h employee

Database "/var/lib/firebird/2.5/data/employee.fdb"
Database header page information:
...
Page size 4096
ODS version 11.2
Oldest transaction 780
Oldest active 781
Oldest snapshot 781
Next transaction 782
...
Creation date Nov 21, 2011 16:21:09
Attributes force write, multi-user maintenance

Variable header data:
*END*


$ fbstat -z

gstat version LI-V2.5.1.26351 Firebird 2.5


You can see that I'm using Firebird 2.5 and I have ODS 11.2. What do you
get for the database you created?

When you run the normal backups, have you ever managed to successfully
create a new database from the backups file? Or is this the first time
you have tried it?

What command line did you use to create the backup?

And finally, you'll be glad to hear, what command line did you use to
create the test one from the backup?


Ok, I lied, on the backing up server what is the output from gbak -z and
what is it on the server where you are trying to create a test database.

Thanks.


Cheers,
Norm.

--
Norman Dunbar
Dunbar IT Consultants Ltd

Registered address:
27a Lidget Hill
Pudsey
West Yorkshire
United Kingdom
LS28 7LG

Company Number: 05132767