Restoring Master Database in Cluster Environment.
Assuming Master DB backup is available.
Environment: Cluster Server
Solution:
Identify which cluster node SQL Server is currently running on, such as node1.
From Cluster Administrator, take the SQL Server resources off-line.
Go to the node running SQL Server (see step 1) and start it from the command prompt using: sqlservr.exe -c -m
Restore the Master database using Query Analyzer or Enterprise Manager.
Quit SQL Server from the command prompt.
Using Cluster Administrator, restart the SQL Server resources
No comments:
Post a Comment