I lost MSDB database in SQL 2005. How do I restore that?

migrated from stackoverflow.com Nov 4 '09 at 19:27

This question came from our site for professional and enthusiast programmers.

  • 4
    Hopefully you have backups. – Raj More Nov 4 '09 at 19:17

check this out



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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.