Sunday, December 27, 2009

Restoring Master Database in Sql 2000

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