clare.xia (2/9/2011)

---

Wow.. I can't believe I got all the attentions from SQL Gurus! This is a great learning experience for me!

Here are the references I have been using. Please let me know if you think some other articles will be helpful.

Fix Suspect DB

http://www.sqlskills.com/BLOGS/PAUL/post/TechEd-Demo-Creating-detaching-re-attaching-and-fixing-a-suspect-database.aspx

Recreate MSDB

http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/06/06/619304.aspx

I appreciate all your helps! SQL is fun!