Subject Re: can not schedule a backup on win 2003 server
Author tbvpresident
--- In firebird-support@yahoogroups.com, "tbvpresident"
<tbvpresident@y...> wrote:
> Hi,
>
> I am running several instances of firebird 1.5 databases on a
Windows
> 2003 Server. I am trying to automate the backups through the
Windows
> Scheduler. The scheduled task runs fine if I am running a console
> session at the time of the scheduled task but it fails without any
> messages if I am not logged onto the console???? I have other
> scheduled jobs of different nature that do run while I do not have
a
> console session but in the case of gbak.exe it does not work. Has
> anyone ever encountered this?

Well after hours of debugging this thing I found the problem and the
solution. The problem is in the syntax. I spooled the output
instead of using the –v for verbose and it finally wrote the
error "unavailable database"!!! The problem is: I am running a non-
interactive service (scheduled task) and firebird only responds to
request in an interactive service… So I used a loopback to attach
to the database through the localhost command (instead of pointing
to the database like "D:\DATABASES\MYDATABASE\DATABASE.GDB" I
switched to "LOCALHOST:D:\\DATABASES\\MYDATABASE\\DATABASE.GDB" and
now it works.

Hope this helps someone.