SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 sql server error
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sparrow37
Posting Yak Master

147 Posts

Posted - 07/17/2009 :  08:16:17  Show Profile  Reply with Quote
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

United Kingdom
3608 Posts

Posted - 07/17/2009 :  08:21:13  Show Profile  Reply with Quote
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.

Edited by - RickD on 07/17/2009 08:22:29
Go to Top of Page

sparrow37
Posting Yak Master

147 Posts

Posted - 07/31/2009 :  07:54:26  Show Profile  Reply with Quote
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

United Kingdom
3608 Posts

Posted - 08/05/2009 :  05:07:29  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000