Posted by Mark D Powell on 02/02/07 17:41

On Jan 31, 5:54 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> Mark D Powell (Mark.Pow...@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 foundhttp://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, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Just now say your response, and yes this option was checked. I am
waiting on a window when I will be allowed to cycle SQL Server to see
if this resolves the problem.

I will post back either way, but it may be a few days till I get a
window.

-- Mark D Powell --

[Back to original message]