Thursday, March 22, 2012

(393) Waiting for SQL Server to recover database

We're running SQL Server 200 SP3, operating in thread mode, and have
recently encountered the following problem.
SQL Server Agent shows as started but if we try to access any jobs we get
the message
"Error 14258: Cannot perform this operation while SQL Server Agent is
starting. Try again later"
When we access the SQL SErver Agent error log the most recent entry is
"(393) Waiting for SQL Server to recover database"
There is no recovery outstanding and we are unable to resolve this by
stopping and starting the agent, the database or the server."Thread mode" '
If you have Fibers switched on, stuff like Agent and xp_cmdshell, sp_OA* and
other functions don't behave as expected.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Onesj" <Onesj@.discussions.microsoft.com> wrote in message
news:2C5CC3DE-07B9-48AB-8110-BD8952A26AE6@.microsoft.com...
> We're running SQL Server 200 SP3, operating in thread mode, and have
> recently encountered the following problem.
> SQL Server Agent shows as started but if we try to access any jobs we get
> the message
> "Error 14258: Cannot perform this operation while SQL Server Agent is
> starting. Try again later"
> When we access the SQL SErver Agent error log the most recent entry is
> "(393) Waiting for SQL Server to recover database"
> There is no recovery outstanding and we are unable to resolve this by
> stopping and starting the agent, the database or the server.|||Fibers are not switched on in this case. Threads are being used.
Any constructive ideas would be appreciated.
"Mike Epprecht (SQL MVP)" wrote:
> "Thread mode" '
> If you have Fibers switched on, stuff like Agent and xp_cmdshell, sp_OA* and
> other functions don't behave as expected.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Onesj" <Onesj@.discussions.microsoft.com> wrote in message
> news:2C5CC3DE-07B9-48AB-8110-BD8952A26AE6@.microsoft.com...
> > We're running SQL Server 200 SP3, operating in thread mode, and have
> > recently encountered the following problem.
> > SQL Server Agent shows as started but if we try to access any jobs we get
> > the message
> >
> > "Error 14258: Cannot perform this operation while SQL Server Agent is
> > starting. Try again later"
> >
> > When we access the SQL SErver Agent error log the most recent entry is
> >
> > "(393) Waiting for SQL Server to recover database"
> >
> > There is no recovery outstanding and we are unable to resolve this by
> > stopping and starting the agent, the database or the server.
>
>sql

No comments:

Post a Comment