Restore master database on a cluster instance | SansSQL

Saturday, September 28, 2013

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
    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

1 comment:

bart hayes said...

Where do you run the restore statement? can't connect in SMSS, 'restore' is not recognized in the command line, cannot connect sqlcmd.

Post a Comment