Posted by Erland Sommarskog on 01/30/07 22:30

Mark D Powell (Mark.Powell@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, 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

[Back to original message]