Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gamaz
Posting Yak Master
104 Posts |
 Posted - 2009-04-29 : 15:49:06
|
| Hi,Suddenly the automated database backup using DB Maintenance Plan has stopped working. When I am going to the JObs section under sql server agent, there is a red crossed out icon against this job. WHen I am on this job and right clicking the property I am getting the following message:Error: 14258: Cannot perform this operation while sqlserveragent is starting. Try again later. I am not sure how to handle this error. I appreciate any help to resolve this issue. Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
gamaz
Posting Yak Master
104 Posts |
Posted - 2009-04-29 : 16:48:19
|
| OK Tara,I checked the event viewer and did not find any relevant information that would relate to the sql server agent problem. Could you let me know possible cause of Error: 14258. Thanks. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
gamaz
Posting Yak Master
104 Posts |
Posted - 2009-04-29 : 17:41:21
|
| Tara,The Services window showed sqlserveragent has started in automatic mode. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
gamaz
Posting Yak Master
104 Posts |
Posted - 2009-04-30 : 12:52:32
|
| No sql job could run successfully. After researching the internet I found that the solution could be by unchecking the fiber mode. Then I had to restart the sql agent and the sql server. This did the trick and it is working now. Thanks for all your advise. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
DB Backup Job for DB Maintenace Plan is not workin