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
>
>
Showing posts with label base. Show all posts
Showing posts with label base. Show all posts
Thursday, March 29, 2012
ERROR 926 dATABSE msdb CANNOT OPEN
Friday, March 9, 2012
error 4064 help me please
TITLE: Microsoft SQL Server Management Studio
No se puede abrir la base de datos predeterminada del usuario. Error de inicio de sesión.
Error de inicio de sesión del usuario 'HOME\jortega'. (Microsoft SQL Server, Error: 4064)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=4064&LinkId=20476
BUTTONS:
OK
Hi,this is a english newsgroups, could you please translate the mentioned error message to an english equivalent ? That would make things easier for us (or even for me) :-)
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de|||
Have a look at the following thread:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=451657&SiteID=1
Thanks
Laurentiu
Subscribe to:
Posts (Atom)