Restoring Master on a Windows 2019 / SQL Server 2019 Cluster


It doesn’t happen often you have to recover systems databases in SQL Server. Most articles cover restoring a master database on a local instance, if you’re lucky for a named instance, but most do not cover a clustered instance.

As with everything in SQL Server, things evolve over time and versions! So, with every new version you prepare for, you also need to re-evaluate the scenarios you already tested for your current SQL Server instances.

As we recently experienced a production instance that lost the ability to reach its SAN hosted database files, due to a glitch of the SAN