Posted by Mark D Powell on 01/31/07 15:06

On Jan 30, 5:30 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> Mark D Powell (Mark.Pow...@eds.com) writes:
>
> > While I was out of the office the Lan Team moved one of my SQL Server
> > 2000 servers to a new network domain. Since then the maintenance job
> > has not ran.
>
> > The error log for the SQL Agents has the message listed in the subject
> > line. I have not found any useful articles on the MS SQL Server
> > site. Anyone know what might be wrong and how to fix it.
>
> I would try
>
> select * from master..sysdatabases
> where databaseproperty(name, 'IsInRecovery') = 1
>
> and see if that finds something. There are a couple of more properties
> for Databaseproperty that you should search for.
>
> --
> 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

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.

-- Mark D Powell --

[Back to original message]