YONGAR Asked: 2009-11-05 11:10:23 +0800 CST2009-11-05 11:10:23 +0800 CST 2009-11-05 11:10:23 +0800 CST How to restore MSDB database 772 I lost MSDB database in SQL 2005. How do I restore that? sql-server 3 Answers Voted Best Answer Raj More 2009-11-05T11:18:50+08:002009-11-05T11:18:50+08:00 check this out http://rip747.wordpress.com/2008/05/26/rebulding-msdb-in-sql-server-2005/ Sajee 2009-11-05T11:17:13+08:002009-11-05T11:17:13+08:00 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 YONGAR 2009-11-05T15:57:23+08:002009-11-05T15:57:23+08:00 I followed the instruction from http://rip747.wordpress.com/2008/05/26/rebulding-msdb-in-sql-server-2005/ and it worked. Thank s Tapori.
check this out
http://rip747.wordpress.com/2008/05/26/rebulding-msdb-in-sql-server-2005/
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.