Overview
In this section, we will cover questions like would you ever need to restore the master and how do you restore the master database.
Explanation
Is there ever a need to restore the SQL Server master database?
The master database would need to be restored in the event it showed corruption during a consistency check. It could also need to be restored if a server becomes corrupt and Windows is reinstalled. After installing SQL Server, the master database that was installed with the instance would need to be replaced with the previous version.
How to restore the SQL Server master database?
The master database cannot be restored in the traditional manner. In fact, if it is significantly corrupted, it may not even allow the service to start.
Check out this separate tip that shows in great detail how to restore a corrupted master database.
Eric has been a SQL Server DBA and Architect in the legal, software, transportation, and insurance industries for over 10 years. Currently he is the Sr Data Architect for Squire Patton Boggs, a leading provider of legal services with 47 offices in 20 countries.
Eric is a 2018-2019 Idera Ace and has co-authored 2 Idera Whitepapers.
He has been a presenter at PASS Summit, IT/DevConnections, SQLSaturdays, the in.sight transportation conference, and the Ohio North SQL Server User’s Group.
- MSSQLTips Awards: Author of the Year Contender – 2021, 2022 | Trendsetter (25+ tips) – 2021
