Thursday, March 29, 2012

ERROR 926 dATABSE msdb CANNOT OPEN

Hi paul
we are using MS SQL Server2000 when we try to take backup we are getting
this Error " Error 926 Data base MSDB cannot Open it has been marked
suspect by recovery"
Please if you solution to solve this problem let us know.
Thanks in advance
S KaliyanSeems your msdb is corrupted. Restore msdb from your mort recent backup(s).
But do investigate why
msdb went corrupt first:
http://www.karaszi.com/SQLServer/in..._suspect_db.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"S Kaliyan" <as_kalyan@.patel-india.com> wrote in message
news:Oqi5ek3MFHA.3788@.tk2msftngp13.phx.gbl...
> Hi paul
> we are using MS SQL Server2000 when we try to take backup we are getting
> this Error " Error 926 Data base MSDB cannot Open it has been marked
> suspect by recovery"
> Please if you solution to solve this problem let us know.
> Thanks in advance
> S Kaliyan
>
>

No comments:

Post a Comment