Board index » delphi » gabak does not backup db when scheduled with windows scheduled tasks

gabak does not backup db when scheduled with windows scheduled tasks

Here is contents of  my bacup batch file Backup.bat:

c:
cd \Delphi\Projekti\mobil\DB\Interb~\
C:\Progra~1\borland\interb~1\bin\gbak -b -t -user SYSDBA -pas masterkey
MojaBaza.GDB MojaBaza.gbk -y MojaBaza.err

When I start this application manualy it works fine. It works even as
scheduled task if I am logged in to windows.

When I am logged off it doesn't create backup file. It doesn't even report
any error messages.

What am I missing?

Is there any way to avoid SYSDBA Password in this scipt. I hate having
password available to anybody who can open the batch file.

Thanks.

Branko

 

Re:gabak does not backup db when scheduled with windows scheduled tasks


What Version of Windows?

Quote
> Is there any way to avoid SYSDBA Password in this script. I hate having
> password available to anybody who can open the batch file.

I think you can set them as environment variables, but this is more scary
than having them embedded into a batch file.

I used to periodically search the NW for the server password as developers
used to leave them in scripts as well.

Jason Chapman
JAC2 Consultancy

Training - Development - Consultancy
Delphi, InterBase, Firebird, OOAD, Development lifecycle assistance,
Troubleshooting projects, QA.....
www: When I get round to it....
Mob: (+44) 07966 211 959 (preferred)
Tel: (+44) 01928 751088

"Branko Starasinic"

Quote
> Here is contents of  my bacup batch file Backup.bat:

> c:
> cd \Delphi\Projekti\mobil\DB\Interb~\
> C:\Progra~1\borland\interb~1\bin\gbak -b -t -user SYSDBA -pas masterkey
> MojaBaza.GDB MojaBaza.gbk -y MojaBaza.err

> When I start this application manualy it works fine. It works even as
> scheduled task if I am logged in to windows.

> When I am logged off it doesn't create backup file. It doesn't even report
> any error messages.

> What am I missing?

> Is there any way to avoid SYSDBA Password in this scipt. I hate having
> password available to anybody who can open the batch file.

Other Threads