I was tasked to do a DR rehersal with one of our test SQL 2008 R2 server last week, while investigating I came across the following post -
http://blogs.technet.com/b/fort_sql/archive/2011/02/01/the-easiest-way-to-rebuild-the-sql-server-master-database.aspx
As it seemed straight forward and quick fix, I decided to follow it and found that I could recover all the system databases in this manner. After recovering the server I ran dbcc checkdb on the system databases and everything looks in order.
As this was a test server I did not have any user databases on it hence unable to test that side of things. I wonder if anyone has tried this in the live environment and have found any issues with it?
I was quite impressed with the speed at which a SQL Server could be recovered by following this method.
Kind Regards
Kailash.