HOW TO: Restore the Master Database in SQL Server 2016
The same holds true for when you restore the master database in SQL Server 2016.
master
HOW TO: Restore the Master Database in SQL Server 2014
I like having a routine. Most people do, I suppose. There’s some comfort in knowing what lies ahead, what comes next. The same holds true for restoring the master database in SQL Server 2014, because it’s the same routine as what I posted for SQL Server 2012. For those of you too lazy to click … Read more
HOW TO: Restore the Master Database in SQL Server 2012
In my seven years as a production DBA I can count on one hand the number of times I have needed to restore the master database as a result of a disaster. With over 180 instances of SQL Server in our care I believe that is a large enough sample size making it safe to … Read more
Restoring SQL 2005 Master Using LiteSpeed
Less than 24 hours after posting a list of things I am thankful for, where I expressed Thanks for not having to restore master, I found myself awake at 3AM in order to restore master after we had a server lose its data drive. Before I got started I decided to check on the definition … Read more
