error while trying to connect the sql server.

Question

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.