SQL Server Performance

MSDB in recovery

Discussion in 'SQL Server 2005 General DBA Questions' started by WingSzeto, Jul 16, 2007.

  1. WingSzeto Member

    After rebooting our SQL 2K5 server (with sp2), teh MSDB is now at 'in recovery' status. Because of it, other user databases are not functioning or not accessible. How can I make the MSDB functioning again without affecting any existing user databases. I don't care I lose any jobs or history. Any help on this is very much appreciated.

    Wingman
  2. Akthar New Member

    do you have a backup of the msdb database?

    AKTHAR
  3. MohammedU New Member

    First check sql error logs for the reason...
    If you have the backup then you restore MSDB like a regular user db after stopping the sql agent...


    MohammedU.
    Microsoft SQL Server MVP
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  4. satya Moderator

    As referred by Akthar if you have a backup you are at safe, if not you have to take backup from another machine (similar setup & sevice pack) and restore here.

    Also check the location where MSDB is stored should be in good health or check for disk free space.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    @http://www.askasqlguru.com/

    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page