At 04:29 AM 19/08/2009, you wrote:

>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.

Not a solution (yet) but this is the wrong procedure for upgrading your database.

Don't try to copy your database *at all*.

Take the backup that you made on the Fb 2.0 server (with the Fb 2.0 gbak executable) and restore *that* under your running Fb 2.1 server, using the Fb 2.1 gbak with the -createdatabase option and a safe restore location. Then you will have a clearer idea of whether you actually have invalid/incorrupt data or simply created a corrupt copy.

./heLen