Using SQL configuration manager, restart instance Restore master from within that SQLCMD windowĦ.

Open a second command window or Powershell session and connect to the server instance using SQLCMDĥ. In that command window, start the instance executable in maintenance mode using a secret command known only to people that have read my postsĤ. Open a command window or Powershell sessionģ. Using SQL Configuration manager, stop the SQL Server instanceĢ. If you only click on one link, click on the 2012 link because that has the details on how to properly test that the restore worked.įor those of you too lazy to click on the links, I will summarize the steps for you here:ġ. The same holds true for restoring the master database in SQL Server 2016, because it’s the same routine as what I posted for SQL Server 2014, which is the same routine as what I posted for SQL Server 2012. This is also true for when you need to restore the master database in SQL Server 2016.

There’s some comfort in knowing what lies ahead, what comes next.

Master db corrupt sql server