Subject Re: [firebird-support] Periodic database slowdown - troubleshooting steps?
Author Thomas Steinmaurer
>>> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Thomas
> Steinmaurer
>
>>>> Here's a related question for you - as I looked at our script for
> v> doing nightly backups, I see a note that says:
>>>>
>>>> "do not use garbage collection (gbak -g) since we run a manual
> sweep
>>>> every night"
>>>>
>>>> Do you know if that's true - we don't need to do garbage
> collection
>>>> via gbak if we are running gfix -sweep?
>>>
>>> Correct.
>>>
>>> If the backup acts as an immediate replacement for the source
> database
>>> after a restore, you also don't need to run a sweep on the source
> database.
>
>
> But what if you are *not* replacing the database?

If you intend to run a sweep on the source database after a backup, you
don't need to garbage collect in the source database during a backup,
thus using gbak -g is fine.


--
With regards,
Thomas Steinmaurer
http://www.upscene.com/