Posted by Erland Sommarskog on 01/31/07 22:54

Mark D Powell (Mark.Powell@eds.com) writes:
> As I suspected none of the databases are reported as being recovered.
> According to the SQL Server Logs everything is fine. But the SQL
> Agent reports that it is waiting to recover databases.
>
> I noticed that the status codes of 64, 128, and 256 were pre-recovery,
> recovering, and not recovered so I looked for these. The best I can
> tell every database is available.
>
> Thanks anyway. Anyone have any other suggestions as to what I can
> look at.

I found http://support.microsoft.com/kb/303287. Could this be applicable?
Note that if you have lightweight pooling enabled, you should be able
to turn it off without first enable "Allow updates".


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: bcp and trigger: missing data in bcp out file
• Prev in forum: Re: BCP error - missing data
• Thread view: Re: SQL Server 2000 SQL Agent Error [393] Waiting for SQL Server to recover databases

[Reply to this message]