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 |
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-71402c70bfe63rd reply.Hope you either have a backup or not many jobs. |
|
|
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 |
|
|
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. |
|
|
|
|
|