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
 New to SQL Server Programming
 sql server error

Author  Topic 

sparrow37
Posting Yak Master

148 Posts

Posted - 2009-07-17 : 08:16:17
Hi all,

I am getting following error after connecting to sql server and /or pressing refresh button in SQL server management studio.

TITLE: Microsoft SQL Server Management Studio
------------------------------

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------
ADDITIONAL INFORMATION:

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)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3175&EvtSrc=MSSQLServer&EvtID=926&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

Regards,
Asif Hameed

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2009-07-17 : 08:21:13
http://social.msdn.microsoft.com/Forums/en-US/sqldisasterrecovery/thread/d9a8bd3b-017c-4ff9-b26c-71402c70bfe6

3rd reply.

Hope you either have a backup or not many jobs.
Go to Top of Page

sparrow37
Posting Yak Master

148 Posts

Posted - 2009-07-31 : 07:54:26
any other solution to this probelm. Sorry for late response. I just tried it and it didnt work. I desperately need to solve this issue on my sql server 2005 db and i dont have backup
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2009-08-05 : 05:07:29
Lets put it this way.. In future, you will remember to take backups regularly if you still work with SQL.
Go to Top of Page
   

- Advertisement -