Subject | gbak backup and restore issue |
---|---|
Author | birddog925 |
Post date | 2009-08-18T18:29:56Z |
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
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