SQL Server 2000 SQL Agent Error [393] Waiting for SQL Server to recover databases

SQL Server 2000 SQL Agent Error [393] Waiting for SQL Server to recover databases

Post by Mark D Pow » Thu, 01 Feb 2007 06:36:58


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.

HTH -- Mark D Powell --
 
 
 

SQL Server 2000 SQL Agent Error [393] Waiting for SQL Server to recover databases

Post by Erland Som » Thu, 01 Feb 2007 07:30:54

Mark D Powell ( XXXX@XXXXX.COM ) writes:

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, XXXX@XXXXX.COM

Books Online for SQL Server 2005 at
http://www.yqcomputer.com/
Books Online for SQL Server 2000 at
http://www.yqcomputer.com/

 
 
 

SQL Server 2000 SQL Agent Error [393] Waiting for SQL Server to recover databases

Post by Mark D Pow » Fri, 02 Feb 2007 00:06:10


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 --
 
 
 

SQL Server 2000 SQL Agent Error [393] Waiting for SQL Server to recover databases

Post by Erland Som » Fri, 02 Feb 2007 07:54:10

Mark D Powell ( XXXX@XXXXX.COM ) writes:

I found http://www.yqcomputer.com/
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, XXXX@XXXXX.COM

Books Online for SQL Server 2005 at
http://www.yqcomputer.com/
Books Online for SQL Server 2000 at
http://www.yqcomputer.com/
 
 
 

SQL Server 2000 SQL Agent Error [393] Waiting for SQL Server to recover databases

Post by Mark D Pow » Sun, 04 Feb 2007 02:41:32


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 --