Subject | Re: Firebird 1.5 maintenance process/tools. |
---|---|
Author | smaugie |
Post date | 2009-03-24T14:30:42Z |
--- In firebird-tools@yahoogroups.com, "Pavel Kutakov" <pvk@...> wrote:
>
> Hello,
>
> 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
> http://www.sqlly.com
>
> --- In firebird-tools@yahoogroups.com, "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.
> >
>