stéphane wrote:
<<
Everyday i sweep the database and i backup it
gfix.exe -sweep
and just after a backup like this :
gbak.exe -B -t -v -z

the probleme is that the sweep can take up to 5 hours to finish and the
backup up to 12 hours to finish :(
i know that in the backup i don't put the -g params (inhibit garbage
collection) but someone say me that
the -g do something else that the gfix.exe -sweep doesn't do ...

>>

I think it is the other way around: sweep can do
something that gbak's GC doesn't do. Sweep does
a more thorough cleaning when no other user is connected, I think.
If the sweep is run before the gbak, then gbak's
GC will not find anything to do and using -g (or
not) should not have any affect.

<<
now i need to know, how often i need to launch the gfix.exe -sweep and
the gbak.exe -B without the -g params ? everydays seam not anymore
possible because of the time taken
by these process...
one time a month ?
thanks by advance for you help

>>

If weekends are quiet periods you could schedule
"gbak -g" to run every night and gfix sweep every weekend.

Note: When I started to use the ServerManager
switch (-se service_mgr) I noticed a significant speedup for gbak.

--
Aage J.