Subject | Re: unattended firebird backup |
---|---|
Author | p_b_turner |
Post date | 2007-02-05T15:01:46Z |
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:
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:
>something
> sorry for the delay.....
>
> quite certain it's not the gbak command itself, but rather
> having to do with either XP or my account on XP. tried this on myomnipotent "localhost:C:\SNC\QADatabase\Firebird\examples\employee.fdb
> 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
>
> " "C:\SNC\QADatabase\Firebird\examples\test.fbk"database
>
> 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
> > > unattended using gbak. I've tried a scheduled batch file,logged
> scheduled
> > > app, and a service app, all with the same result. if i'm
> in,tried
> > > 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.
> > > 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
> >
>