|Subject||Re: [firebird-support] Failed restore|
> I am using FB 1.5 Classic on Win2003 Server. Each night we have an automated processMay one of the tables reach limit ~36GB on pre-ODS 11 ?
> 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.
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.May i ask you to try FB 2.0 (or 2.1 as it must be faster) to restore this backup ?
> The error message from this morning was:
> gbak: cannot commit index PK_REPORT_USER_PARAMS
> gbak: ERROR: I/O error for file "E:\IB\DELPERF\BACKUP\RESTORE_MON\FDS.GDB"
> 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.