Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error:- 14258 Cannot perform this operation while SQLServerAgent is starting. Try again later. Expand / Collapse
Author
Message
Posted Sunday, May 25, 2014 3:54 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 11:05 PM
Points: 557, Visits: 493
Dear All,

Need your help to resolve following error.

Error :- 14258 Cannot perform this operation while SQLServerAgent is starting. Try again later.

SQL Server Version.:- SQL server 2005 SP4.

One of my database is in recovery state.
Post #1574369
Posted Sunday, May 25, 2014 5:29 AM This worked for the OP Answer marked as solution
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 11:05 PM
Points: 557, Visits: 493
Hi All,

My issue is resolved, when my user database completely recovered.

But still it is confusing why my all SQL Server agent jobs where not run as it was user database which was in recovery state.

Post #1574378
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse