Subject Re: [firebird-support] Scheduled Backup
Author Aage Johansen
donjules2k wrote:

> Is there a way to schedule a backup with firebird? Also, if there is
> can I put the date in the filename so I know when the backup is of?

This is for Windows:

Create a batch file (C:\bckp.cmd) with these 2 commands (just 2 lines!)
del C:\BCKP\db.gbk
"C:\Program Files\Firebird\Firebird_1_5\bin\gbak" -b -v -user SYSDBA -passw
masterkey D:\DB\db.fdb C:\BCKP\db.fbk

Give this command at the CMD prompt (assuming the scheduler (AT) is running):
at 18:00 /interactive /every:M,T,W,Th,F,S,Su C:\bckp.cmd

and you will have a periodic backup (if I didn't mess up anything...).
You can do the scheduling interactively as well, not only with the AT program.

I dont think you can build a DATE/TIME into the filename, unless you manage
to do some fancy renaming after the backup finishes.

Aage J.