Restore master database on a cluster instance
Below is the sequence for restoring master database on a cluster instance
- Take SQL Server Service Offline from Cluster Admin
- Login to the active node of the cluster
- Start the SQL Server service in single user mode
net start "SQL Server (InstanceName)" /c /m /T3608 - RESTORE master database1
RESTORE
DATABASE
master
FROM
DISK =
'<BackupLocation>'
WITH
REPLACE
- Once the master database is restored, the SQL Service will be shutdown automatically
- Start SQL Server Service from Cluster Admin