Subject Re: [firebird-support] Re: What's the difference between "Gbak -g" and "gFix -sweep"
Author Ann W. Harrison
svanderclock wrote:
> I want to ask if :
> Gbak (without -g)
> and
> "gFix -sweep

No. First, gbak creates a backup file. You could direct that
to the null device, but it's still going to go over all data,
metadata, and procedural objects and try to make a copy of them
that can be restored. Second, gfix -sweep resets the value of
the "oldest interesting transaction". That reduces the cost
of some internal bookkeeping.

If you want both effects, setting the oldest interesting
transaction to the oldest transaction that was running when
the sweep started and creating a backup file, you could run
the sweep first then a gbak with -g since there will be
little or nothing to garbage collect.