|Subject||Re: Firebird 1.5 maintenance process/tools.|
--- In email@example.com, "Pavel Kutakov" <pvk@...> wrote:
> To keep your database healthy you should perform regular backup, garbage collection and validation. For regular backups I would recommend our "Time To Backup" package (see http://www.sqlly.com/timetobackup.html).
> To prevent possible database corruptions and monitor database health more closely I would recommend FBDataGuard (see http://www.ib-aid.com/products/firebird_interbase/protection_tools/IBDataGuard-FBDataGuard for details).
> Best regards,
> Pavel Kutakov
> SQLLY Development
> --- In firstname.lastname@example.org, "smaugie" <smaugie@> wrote:
> >Thanks for the suggestions. We have had issues with Guard on IB but we do back-up on a regular basis. I am mainly interested in keeping the indexing healthy and the internals. It appears sweeping is one of the best things to do on a regular basis as well as back-up.
> > We have a manufacturing application written in Delphi 4.0 being moved to Firebird 1.5 for our first Firebird release using MS Enterprise Server '08 & '03 along with MS Windows XP Pro and MS Business Vista. What is the recommended maintenance procedure/tools to keep the Firebird database healthy? Our next release will be on Firebird 2.0.5 or 2.1.1 (not sure yet) and possibly adding an Umbuntu environment.