you can download an backup app for firebird i wrote a very simple one that is in www.firebase.com.br (sorry, is portuguese site) but look for firebackup, is in delphi, just move the code to an service app, it works fine... if you don't use delphi contact me, I will try to give you this service runing...


Julio Cesar

----- Original Message -----
From: Raith, Daniel
To: firebird-support@yahoogroups.com
Sent: Friday, March 09, 2007 4:34 PM
Subject: [firebird-support] Scheduled backup task


I have scheduled daily backup and weekly backup/restore tasks using
batch files and windows scheduled tasks.

Now the server is being rebooted now and again and my backup tasks are
failing if nobody logs into the computer before the task tries to run.

I modified the batch file and added a -Y option to output the results to
a text file. This is what I found the next day in the output file.

gbak: ERROR: unavailable database
gbak: Exiting before completion due to errors

Does anyone have any pointers as to why someone has to be logged in?

Here is a sample batch file that ran last night.

"C:\Program Files\Firebird\Firebird_1_5\bin\gbak.exe" -B
"C:\SOAPServices\myService\mydatabase.fdb"
"C:\SOAPServices\myService\mydatabase.fbk" -user sysdba -pass masterkey




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