Search This Blog

Restore master database on a cluster instance

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