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 |
|
desikankannan
Posting Yak Master
152 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-08-09 : 02:33:24
|
| "Database 'msdb' cannot be opened. It has been marked SUSPECT by recovery."If you had just rebooted, and MSDB is large, maybe it is still starting up.Otherwise it is damaged and most probably needs to be restored (not sure if you can run DBCC CHECKDB on a Suspect database, but if you can that would give you more information about any damage to that database.If MSDB is huge it may be because the backup history is not being cleared down (this doesn't happen routinely unless you set up a task to do it). |
 |
|
|
desikankannan
Posting Yak Master
152 Posts |
Posted - 2010-08-09 : 03:10:09
|
Hi,i don't no how to run dbcc checkdb pls guide me looking forward your replyquote:
Originally posted by Kristen
"Database 'msdb' cannot be opened. It has been marked SUSPECT by recovery."If you had just rebooted, and MSDB is large, maybe it is still starting up.Otherwise it is damaged and most probably needs to be restored (not sure if you can run DBCC CHECKDB on a Suspect database, but if you can that would give you more information about any damage to that database.If MSDB is huge it may be because the backup history is not being cleared down (this doesn't happen routinely unless you set up a task to do it).
Desikankannan |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-08-09 : 04:06:20
|
| http://msdn.microsoft.com/en-us/library/ms176064.aspx |
|
|
|
|
|
|
|
|
new database problem