Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DBBACKUP does not work from scheduler

Status
Not open for further replies.

dafdba

Technical User
Dec 6, 2002
10
NL
I created a script which makes an online backup of a SQL Anywhere 5.5 database on a Windows NT4.0 server. This script runs fine when it's started from the commandline on the server. When I start the script from the scheduler AND nobody is logged on to the server it fails with the error message: Unable to start database engine. The backup command I use is:
dbbackup -c "start=dbclient -x tcp %ENG%;uid=%UID%;pwd=%PWD%;eng=%ENG%;dbn=%DBN%" -o %BACKUP_DIR%\%LOG_FILE% -d -t -x %BACKUP_DIR%

I have the same script running on another server, that one runs fine under all circumstances.

Are there settings on the server which I have to change or do I have to add extra connection parameters ???
 
Is this script sheduled on another computer than the server ?
In that case, you should use a user that has rights on this server for your sheduled job.

Wim Vanherp
 
The script is running on the same server as the instance is running
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top