error while trying to connect the sql server.

Hi.

When i was opened the SSMS 2008 and press connect button to connect the local database i got the error "an exception occurred while executing the transact-sql statement or Batch (Microsoft.SqlServer.ConnectionInfo)" and Additional information : Database 'msdb' can't be opended. It has been marked by SUSPECT by recovery. see the sql server errorlog for more information. (Microsoft SqlServer, Error:926)

I tried the following this to solve this problem. but i can't solve.

EXEC sp_resetstatus 'test'

ALTER DATABASE test SET EMERGENCY

DBCC CheckDB ('test')

ALTER DATABASE test SET SINGLE_USER WITH ROLLBACK IMMEDIATE

DBCC CheckDB ('test', REPAIR_ALLOW_DATA_LOSS)

ALTER DATABASE test SET MULTI_USER

and cut the MSDBDATA and MSDBlog file from server folder and paste in another place and copy that file and again place that in older place.

but i got the same error still now. can any one help me to solve this problem.

Thanks in advance.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Vinay Singh10y ago
Hi
Have a look of couple of solution which i found.
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/6ccb54e0-85d5-4892-ae23-991ae7d19870/failed-to-retrieve-data-for-this-request?forum=sqlexpress
https://technet.microsoft.com/en-us/library/aa258745%28v=sql.80%29.aspx
http://stackoverflow.com/questions/16229415/database-msdb-can-not-be-opened