Back up exec not perfoming nighlty schedule; error message "job did not start"

I’m trying to back up the database from an SQL 2000 server running on Win 2003 using backup exec 9.1

During the nightly schedule I get an error message “job did not start”.  This has been going on for sometime now. I deleted and recreated the full back up schedule along with running the postscript to stop and start the SQL server but still it’s a no go. The manual back up works just fine..Just the schedule back does not.


Your comments are appreciated and thank you in advance.

~LandofOz
LandofozAsked:
Who is Participating?
 
mrwaqarConnect With a Mentor Commented:
Yes! Failing of SQL service restart could be a reason. But to make sure, try a manual backup without restarting the SQL service and see if that fails. If it doesnt fail then restarting of SQL service is not an issue. Otherwise you need to look into the script you have scheduled for restart of SQL server. May be backup exec is not waiting for the service to completely stop before it starts the backup? You could also try restarting the SQL service by running the script which you have scheduled before the backup.
Good luck!
0
 
rindiCommented:
Did any windowsupdates run? You could try uninstalling the last ones.
0
 
LandofozAuthor Commented:
Ill check when the last updates took place.
0
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
rindiCommented:
Another thing I forgot to ask, is there anything unusual in the event logs, and maybe a service that should start not starting?
0
 
LandofozAuthor Commented:
Im not failiar with backup exec could yo be more specific on the service that needs to start. Would it be part of the automated process.

The maunal backup does work but the only diff is that I stop and start the SQL. Maybe its the script thats not working?

Do you know were I might find a smaple script?
0
 
LandofozAuthor Commented:
sorry about all the typos..LOL
0
 
johanvz1Commented:
Hi,

Can you put the error information in your log file on here so I CAN HELP you better as that would give you much better info ie if the tape is faulty if the device was not ready and so forth.
0
 
rindiCommented:
With service I just mean, look in the services and look at those that are set to start automatically and maybe aren't running.
0
 
MasPreguntasCommented:
Perhaps you need the Advanced Open File to be turned on? I haven't backuped SQL before, but I think you could leave it running and not stop it using AOF.
0
 
cooleditCommented:
hi, there

You are stating the OS is a Windows 2003 is the SP 1 installed, had the same issue with a customer solved by SP 1.



Cooledit
0
 
LandofozAuthor Commented:
Thanks for all the tips...Ill try them out this week.

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.