Subject RE: [firebird-support] slower backup after upgrade from classic to superserver
Author Alan McDonald
> Hello,
>
> I have the problem, that the backup time is grown up very high after
> the upgrade from the classicserver (1.0) to the superserver (1.5).
> With the classicserver gbak makes the backup for a 5 GB database in 30
> to 40 minutes. After the upgrade the same backup needs more then 3 hours.
> An other 19 GB database needs more then 8 houres.
> The restore ist very slow too and this is my greatest problem. The
> databases are used in medical environments and more then 3 or 8 hours
> for a restore is a very long time.
>
> Thanks for your help
>
> Erich

let's do a reality check as well. Let's suppose for a minute we get this
time down to 40 minutes again.
How often are you restoring such that the restore is the file your users are
then using instead of the original?
I see no need for a restore cycle back to a restored file on a regular
basis.
Do regular backups with garbage collection.
Do regular restores to a test file to check data integrity and validate the
backup.
Do very infrequent cycles where the users must wait for the restored file.
Alan