Subject Re: backing up problem
Author Aage Johansen
Tom wrote:
Firebird 1.02 / Windows 2000 Server
I'm trying to write up a .vbs script to be used by the schedular to
backup my firebird database regulary. So for it works when I'm logged
in and just run the scheduled task.
However, when I leave the PC at it's login screen, there seems to go
something wrong when the tasks starts. The gbak gives an error 1.
What's the cause of this? Why doesn't it works when I'm not logged
in. I let the script run as the same user as when logged in.

Why not just use the Win2k scheduler (AT).

Run the backup with something like (all on one line):
"C:\Program Files\Firebird\bin\gbak" -b -v -user SYSDBA -passw masterkey
D:\PATH\DB\mydatabase.gdb C:\PATH\DB_BCKP\mydatabase.gbk

Put the above line in a file (e.g. bckp.cmd), and run the following from
the command prompt:
at 01:00 /interactive /every:M,T,W,Th,F,S,Su bckp.cmd
This will run the backup (gbak) at 01:00 every night.

>Is it needed to shutdown firebird each time when making a backup?

No, it is not.
Btw, doing a sweep after the backup can be a good thing - put the
appropriate command into the same file (bckp.cmd).

Aage J.