June 2, 2009 at 1:07 pm
Hi Team,
In my production server msdb database is in suspect mode??
may i know How to do???
Thanks
Ram
June 2, 2009 at 4:59 pm
Check the error log. There should be some entry in there saying why MSDB is suspect.
Do you have a backup of MSDB?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 11, 2009 at 7:33 am
Hi Ram,
Post at this link will definitely help you in recovery of MSDB database:
http://www.sqlservercentral.com/Forums/Topic399609-266-2.aspx
Cheers 🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply