When I started blogging, way back in 2006 :-), the third post I made on the old Storage Engine blog was about rebuilding the msdb database in 2005 (see here). This no longer works in 2008 (fellow MVP Tibor Karaszi explains why here), and in fact the information in Books Online about how to rebuild any of the 2008 system databases is incorrect. It’s not something I’ve tried yet but people have already needed to do it (including Tibor!). So what to do? Step in Bob Ward, a Principal Escalation Engineer with PSS, and a very good friend of mine. He’s just researched and published a comprehensive blog post giving the procedure for rebuilding the system databases in 2008 using setup.exe. Checkout his great post here. Here’s hoping that you never need to do it!
2024: the year in books
Back in 2009 I started posting a summary at the end of the year of what I read during the year and people have been
One thought on “SQL Server 2008: How to rebuild the system databases?”
how to backup and restore system database from one server to another server