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.
