I lost MSDB database in SQL 2005. How do I restore that?
3 Answers
If you want to rebuild: http://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/06/619304.aspx
If you want to restore from backup: http://msdn.microsoft.com/en-us/library/ms190749.aspx
I followed the instruction from http://rip747.wordpress.com/2008/05/26/rebulding-msdb-in-sql-server-2005/ and it worked. Thank s Tapori.