It's trivial to achieve this with existing open source application. I have an application that runs 24/7. I setup FIBS http://www.talatdogan.com/fibs.htm on an client and have it connect to my database server and create backups in a zipped format.
We have 3 back up jobs for the same Db. One performs an hourly backup. Another does a "day end" back up(see below). The third does a month end backup. Hourly backup are maintained for 1 day and then deleted. Day end are maintained for 1 weeks and then automatically deleted. Monthly backups are maintained permanently.
Day end jobs are scheduled for when the database load is low - this job triggers garbage collection - others do not.
FIBS allows you to maintain a certain number or back versions of each back up job - based on time (eg: last 5 days) or number of backup (last 10 backup). Hope this helps.




-----Original Message-----
From: brcr11 <brcr11@...>
To: firebird-job-board@yahoogroups.com
Sent: Tue, 19 Feb 2008 9:42 am
Subject: [firebird-job-board] Re: Firebird database maintenance and eventual recovery

























--- In firebird-job-board@yahoogroups.com, "Jean-Louis Dehoux"

<dehoux@...> wrote:

>

> We have a Point of Sale software using Firebird as RDBMS.

> I need a robust maintenance (and eventual recovery) application for

> the database.

> Successive versions of the software are always backward compatible

but

> sometimes introduce changes to the database schema.

> It seems that IBReplicator would be a logical part of the solution

but

> its setup is quite complex for computer illiterate people.

> Could you develop an easily installed one-click solution (if

possible)

> to backup and maintain the Firebird database.

>

A one click solution to backup and restore a Firebird DB is

quite simple if your desire is simply to give your users that

capability. If however you are talking about the ability to modify

DB content it's quite a bit more involved. I assume you are

definitly NOT talking about changing the DB structure.

There is a free utility on the web call IBEasy that handles DB

administration but is not user friendly for your typical end user.

It is quite handy for DB administration.

A simple utility to just do the backup and restore is no more

than a day or two effort. A nice user friendly GUI interface to look

at and modify DB content is of course more involved and dependent on

the complexity of the DB.

I have done all this several times. If you are serious about

pursuing this I can be contacted at (850) 492-8743. I'm sure we

could work out an arrangement that would be beneficial to both of us.

Thank you, Bob Ritter





















________________________________________________________________________
More new features than ever. Check out the new AIM(R) Mail ! - http://webmail.aim.com


[Non-text portions of this message have been removed]