Baburajpv


Hello Friends,

I my sql server, the microsoft db msdb is displaying as Suspect. As a result of this, many of the transaction that involves SQL server fails. Is there any solution to correct this db without reinstalling SQL Server. Will it work if I copy the msdb of another SQL Server to my server and attach that database to mine.

Thanks and regards,

Babz




Re: Restore MSDB without reinstalling SQL server

Jens K. Suessmeyer


Hi,

you sure have a backup of MSDB, then you can use the following article:

http://msdn2.microsoft.com/en-us/library/ms190749.aspx

If not, you can try to attach the files shipped with the original install media. This might work in your case, but changes in your original msdb database (jobs etc) will be lost.


Jens K. Suessmeyer

---
http://www.sqlserver2005.de
---