SQL Server Performance Forum – Threads Archive
MSDB in recovery
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. Wingmando you have a backup of the msdb database? AKTHAR
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.
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.
]]>