Stefan Heymann wrote:

>>Is it possible to write a sp to do daily schedule backup?
>
> No, for two reasons:
> - there is no timer/scheduler in Firebird
> - you can't start a backup from a stored procedure.
>
> You can use your OS's scheduler (AT, cron) and start a shell script
> that calls the GBAK tool from the Firebird bin folder.

Alternatively try one of the backup tools
You will find a few options on
http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_admin_tools

--
Lester Caine - G8HFL
-----------------------------
L.S.Caine Electronic Services - http://home.lsces.co.uk
Model Engineers Digital Workshop -
http://home.lsces.co.uk/ModelEngineersDigitalWorkshop/
Treasurer - Firebird Foundation Inc. - http://www.firebirdsql.org/index.php