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. Login to the instance using sqlcmd
  5. RESTORE master database
    RESTORE DATABASE master FROM DISK = '<BackupLocation>' WITH REPLACE
  6. Once the master database is restored, the SQL Service will be shutdown automatically
  7. Start SQL Server Service from Cluster Admin
Posted by Sandesh Segu
Labels: ,

1 comment:

Unknown said...

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

February 22, 2016 at 11:13 AM

Post a Comment

Subscribe to: Post Comments (Atom)

Ads