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.
| Author |
Topic |
|
indianhunk
Starting Member
7 Posts |
 Posted - 2012-12-10 : 01:44:18
|
| Dear friends,First of all I thank you all and this forum which became very helpful for me. I am learning new things and getting my problem solved.Now my problem is that I am getting msdb suspect error. Whenever I try to create backup it shows a message like-Error 926: Database 'msdb' cannot be opened. It has marked 'suspect' by recovery.will i have to reinstall sql server or theres any other method to solve it.Thank you!! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2012-12-10 : 08:02:43
|
| Do with sp_resetstatus 'DBName'. Do you have backups for msdb before it marked as suspect. Find the cause of it by checking in Event viewer. |
 |
|
|
indianhunk
Starting Member
7 Posts |
Posted - 2012-12-13 : 03:46:48
|
quote:
Originally posted by sodeep
Do with sp_resetstatus 'DBName'. Do you have backups for msdb before it marked as suspect. Find the cause of it by checking in Event viewer.
Thank you sodeep for your reply. No i dont have backups of msdb. |
|
|
|
|
|
|
msdb suspect error