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.