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
 Data Corruption Issues
 Sql Agent 2005 failed to start due to MSDB issue

Author  Topic 

zaty2405
Yak Posting Veteran

58 Posts

Posted - 2011-08-01 : 05:58:23
Hi ,

I am not able to start my SQL Agent .

When tried to open SSMS 2005 , I encountered the following error :

"
Database 'msdb' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information. (Microsoft SQL Server, Error: 926) "

I run sp_resetstatus msdb and restart services but still failed to start SQL agent and fix the MSDB issue .

Is restoring msdb from backup is the only solution ?

Thank you

zaty
   

- Advertisement -