after more digging and adding "-Y gbak.txt" to the end of my command
in the bacth file, i think i've determined that it's related to
Firebird Guardian not running. yes, while i am running XP and could
run FBGuard as a service, we have customers that use our product on
WIndows 98, which doesn't have services. my XP config has FBGuard as
a startup application when i log in. stopping the app in the system
tray results in interactive backups not working. restarting it, they
are OK.

now comes the fun part...how to get FBGuard to run from inside the
batch file. any thoughts/suggestions?

thanks.

Pete Turner

--- In firebird-support@yahoogroups.com, "p_b_turner"
<PeterTurner@...> wrote:

>
> just to keep the message thread updated....
>
> in doing a bit of research on the Microsoft site, it appears that
> there is an account setting "Log on as a batch job" which allows an
> account to log on to the task scheduler. more specifically, the
> setting is not defined for interactive users (meaning that it's
> allowed) and it's defined in the SSLF for non interactive users.
> since my account on my home machine (Win 2000) is a member of the
> administrators group, it works, but at work, i'm not in that

group.

> have an e-mail in to the local admin to work with me to enable this
> setting for my account.
>
> there was also some discussion about changes to the task scheduler
> interface with XP SP2 which "may cause some tasks not to be run".
> this also may be related to the above (account settings).
>
> will update the message thread as i find out more.
>
> pbt.
>
> --- In firebird-support@yahoogroups.com, "p_b_turner" <PBTiam@>
> wrote:
> >
> > sorry for the delay.....
> >
> > quite certain it's not the gbak command itself, but rather
> something
> > having to do with either XP or my account on XP. tried this on

my

> > home machine (win 2000 pro), both logged in and not, and in both
> > cases, it worked. sent the batch file to myself at work. tried

it

> > here and it only works if i'm logged in.
> >
> > just in case....here's the script line....
> >
> > note: our installation path is different from the standard -
> > c:\SNC\QADatabase, and the password is changed.
> >
> > "C:\SNC\QADatabase\Firebird\bin\gbak" -b -user SYSDBA -pass
> >
>

omnipotent "localhost:C:\SNC\QADatabase\Firebird\examples\employee.fdb

> > " "C:\SNC\QADatabase\Firebird\examples\test.fbk"
> >
> > thanks,
> >
> > pbt.
> >
> > --- In firebird-support@yahoogroups.com, "Adam" <s3057043@> wrote:
> > >
> > > --- In firebird-support@yahoogroups.com, "p_b_turner" <PBTiam@>
> > wrote:
> > > >
> > > > Hi all,
> > > >
> > > > Looking for a solution where I can backup a Firebird 1.5
> database
> > > > unattended using gbak. I've tried a scheduled batch file,
> > scheduled
> > > > app, and a service app, all with the same result. if i'm
> logged
> > in,
> > > > all work fine. if i'm logged out, none run. if i lock the
> > terminal,
> > > > it works. came across a discussion (message 65333, etc.)

where

> > it
> > > > talks about adding localhost: to the path of the database.
> tried
> > > > this with no luck.
> > > >
> > > > this is currently being developed on Windows XP, but would

like

> > > > something that would run across various Windows platforms

(98,

> > 2000,
> > > > 2003, XP, Vista) - which is why I was leaning towards the

task

> > > > scheduler.
> > > >
> > > > note: all path references in apps and batch files are fully
> > qualified
> > > > (eg. c:\directory\...., no "assumed" paths).
> > > >
> > > > Any thoughts, suggestions, comments would be welcome.
> > >
> > > It works for me on 2000 server, 2003 server and XP. Post your

gbak

> > > command line.
> > >
> > > Adam
> > >
> >
>