Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 MSDB database in suspect mode

Author  Topic 

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2007-09-21 : 06:15:45
Dear Experts,
I'm using sql server 2005, and now i'm trying to restore with one backup. then i'm getting error saying that MSDB database in suspect mode.

how to make the DB to the normal mode....
please help me in this regard

Vinod
Even you learn 1%, Learn it with 100% confidence.

Kristen
Test

22859 Posts

Posted - 2007-09-21 : 07:06:31
Did you use the RECOVERY command in your Restore?

Probably best to post the exact syntax you used for the Restore here pls.

See also: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=RESTORE%20syntax%20/%20example

Kristen
Go to Top of Page
   

- Advertisement -