MSDB SUSPECT MODE??

• Ram-1104378

  SSC Veteran

  Points: 203

  More actions

  June 2, 2009 at 1:07 pm

  #201008

  Hi Team,

  In my production server msdb database is in suspect mode??

  may i know How to do???

  Thanks

  Ram

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  June 2, 2009 at 4:59 pm

  #1003701

  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

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• ankur_libra

  Hall of Fame

  Points: 3999

  More actions

  June 11, 2009 at 7:33 am

  #1007988

  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