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
 SQL Server 2000 Forums
 SQL Server Development (2000)
 msdb suspect error

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.
Go to Top of Page

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.
Go to Top of Page
   

- Advertisement -