Subject gbak backup and restore issue
Author birddog925
I am trying to restore a database (grantmgt.gdb) on a Firebird 2.1 server that was backed up on a Firebird 2.0 server. The database appears to be OK on the Firebird 2.0 server.

I have shut down the Firebird 2.0 server, and copied the database to the Firebird 2.1 server and attempted to back up the copied database on the Firebird 2.1 server.

gbak -b -v grantmgt.gdb grantmgt.H18 -user SYSDBA -pas masterkey -t

It fails with:

gbak: writing data for table FINANCIALREPORT
gbak:2000 records written
gbak: ERROR:value exceeds the range for valid dates
gbak: ERROR: gds_$receive failed
gbak:Exiting before completion due to errors

When I attempt to restore a backup created on the Firebird 2.0 server it also fails on the same table.

gbak -rep -v -user SYSDBA -pas masterkey -p 4096 grantmgt.%1 grantmgt.gdb


I get the following error:

gbak: restoring data for table FINANCIALREPORT
gbak:1000 records restored
gbak:2000 records restored
gbak: ERROR:value exceeds the range for valid dates
gbak: ERROR: gds_$receive failed
gbak:Exiting before completion due to errors

Any thoughts would be most appreciated.

Steven