Subject | Scheduled backup task |
---|---|
Author | Raith, Daniel |
Post date | 2007-03-09T16:34:21Z |
I have scheduled daily backup and weekly backup/restore tasks using
batch files and windows scheduled tasks.
Now the server is being rebooted now and again and my backup tasks are
failing if nobody logs into the computer before the task tries to run.
I modified the batch file and added a -Y option to output the results to
a text file. This is what I found the next day in the output file.
gbak: ERROR: unavailable database
gbak: Exiting before completion due to errors
Does anyone have any pointers as to why someone has to be logged in?
Here is a sample batch file that ran last night.
"C:\Program Files\Firebird\Firebird_1_5\bin\gbak.exe" -B
"C:\SOAPServices\myService\mydatabase.fdb"
"C:\SOAPServices\myService\mydatabase.fbk" -user sysdba -pass masterkey
batch files and windows scheduled tasks.
Now the server is being rebooted now and again and my backup tasks are
failing if nobody logs into the computer before the task tries to run.
I modified the batch file and added a -Y option to output the results to
a text file. This is what I found the next day in the output file.
gbak: ERROR: unavailable database
gbak: Exiting before completion due to errors
Does anyone have any pointers as to why someone has to be logged in?
Here is a sample batch file that ran last night.
"C:\Program Files\Firebird\Firebird_1_5\bin\gbak.exe" -B
"C:\SOAPServices\myService\mydatabase.fdb"
"C:\SOAPServices\myService\mydatabase.fbk" -user sysdba -pass masterkey