> I have a question on backup/restore. > > Think of a firebird classic on a linux box. > > -Do a backup with existing attachments > -After backup, Rename the old gdb file to something else > -Restore the backup file with the original gdb name.
You have to kill all connected clients before starting backup and you have to prevent them from reconnecting until restore is complete. Else at least the updates done while backup/restore are lost. In Addition existing connections should prevent you from renaming the database. As an alternative you should consider if restore&rename is really required. Just run the backup and do an restore to an dummy database to verify backup file. It is not required to rebild database on each backup. Elmar