Subject Re: [firebird-support] Re: What's the difference between "Gbak -g" and "gFix -sweep"
Author Ivan Prenosil
> Ok, so in conclusion doing everyweek (cause everydays i can't too
> long process that slow down the database)
>
> First
> fgix -sweep
>
> and immediatly after
> gbak (without -g)
>
> it's a good practice? everyone agree ?

Sweep does two things:
- garbage collect whole database
- fix transactions states

I.e. immediately after doing sweep you do not need
to do garbage collection, so this is usual procedure:

fgix -sweep ...
gbak -g ...

(otoh, since garbage is already collected by sweep,
you will probably do not see any difference between
gbak with/without -g)

Ivan
http://www.volny.cz/iprenosil/interbase/