I am a administrator on the server and I wrote a scripts to backup the database. Anyway, when I executed the scripts manually, it ran successfully. When I used to TASK SCHEDULER to schedule the job to be run, it ran sucessfully IF I AM STILL LOG ON THE SERVER; However, when I log off the server, BACKUP IS NOT RUNNING but on the Task schedulers show that it executed and schedule to be run next time.
I suspect it had something to do with some of the services are not running on the server.
Does anyone have any thoughts or advises????
thanks,
I suspect it had something to do with some of the services are not running on the server.
Does anyone have any thoughts or advises????
thanks,