Results 1 to 3 of 3

Thread: [393] Waiting for SQL Server to recover databases...

  1. #1
    Ron Guest

    [393] Waiting for SQL Server to recover databases...

    We have a two node cluster running W2K and SQL2000. The agent starts, but we cannot access any of the jobs. It gives us the 14258 Agent is starting, try again later... error message. We know that this is not the case, we have waited several hours without it "starting". The SQL Agent log indicates that the agent is waiting on SQL Server to recover databases, but all of our databases are up. It is almost as if during startup a flag did not get set to indicate that a database was recovered.

    Has anyone run across this before? If so, did you ever figure out how to fix it?

  2. #2
    Join Date
    Sep 2005
    Location
    Wellington
    Posts
    1

    To stop "fiber mode" (Lightweight pooling)

    To change from Fiber Mode simply perform the following in Query Analyzer then restart the SQL Services;
    SP_CONFIGURE 'Allow Updates', 1
    GO
    RECONFIGURE WITH OVERRIDE
    GO
    sp_configure 'Lightweight Pooling', 0
    GO
    RECONFIGURE WITH OVERRIDE
    GO

  3. #3
    Join Date
    Sep 2002
    Posts
    5,938
    You can find db recover messages in sql server log, ensure msdb is recovered.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •