Subject Re: [firebird-support] Re: Gbak Restore - SuperServer vs. SuperClassic
Author Helen Borrie
>> * How does your gbak restore call look like?
>> GBak -C -User %1 -Pas %2 G:\FBDump\OCCEasyPos.fbk
>> "LocalHost:F:\DB\Kaufmann\Uddannelse\OCCEasyPos.fdb" -v -rep -o
>> -FIX_FSS_METADATA ISO8859_1 -fix_fss_data ISO8859_1 -y "G:\FBDump\
>> ;RestoreEasyPos.txt"

At 09:03 a.m. 18/11/2014, Robert martin rob@... [firebird-support] wrote:

>Have you tried it with the -G flag. This disables garbage collection,
>which can make backups run much faster. Obviously if you need / want to
>do the garbage collection this isn't an option but if it works much
>faster it gives you a hit as to what the issue might be :)

OP is complaining of a slow restore. It makes no difference to the restore, whether the backup was made with or without the -g flag.

But it's good advice to use the -g flag for a BACKUP that is going to be restored right away, since the original database is going to be dropped, anyway, garbage-and-all.

Helen Borrie, Support Consultant, IBPhoenix (Pacific)
Author of "The Firebird Book" and "The Firebird Book Second Edition"