Subject Re: [firebird-support] Failed restore
Author Vlad Horsun
> I am using FB 1.5 Classic on Win2003 Server. Each night we have an automated process
> that runs on a different Win2003 server that backs up the production database to a backup
> file on this secondary server. After a successful backup, the secondary server attempts to
> restore the database to a local file.
> Originally we did the backup/restore on the production server. However, since the production
> database is about 45GB, the backup/restore window overlaps the start of the workday, affecting
> production performance. Therefore, we moved the process to the secondary server, with the
> only network overhead occurring the backup process.

May one of the tables reach limit ~36GB on pre-ODS 11 ?

You can run gstat -t TABLE to calculate size of biggest TABLE in your db

> Over the last three nights, we have received an error message when the restore is nearly complete.
> The error message from this morning was:
> gbak: cannot commit index PK_REPORT_USER_PARAMS
> gbak: ERROR: Error while trying to read from file
> gbak: ERROR: Reached the end of the file.
> gbak: ERROR: action cancelled by trigger (3) to preserve data integrity
> gbak: ERROR: Cannot deactivate primary index
> gbak: Exiting before completion due to errors
> The error always mentions an index, but usually a different one each time.

May i ask you to try FB 2.0 (or 2.1 as it must be faster) to restore this backup ?