Showing posts with label databse. Show all posts
Showing posts with label databse. Show all posts

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
>
>