:::: MENU ::::

How do you restore the master database on a SQL Server cluster?

  • Nov 21 / 2008
  • 0
Backup and Restore, dbDigger, System Databases

How do you restore the master database on a SQL Server cluster?

Use following steps for SQL Server 7.0 and SQL Server 2000 to restore the master database on a SQL Server cluster

  1. Identify which node SQL Server is currently running on, such as node1.
  2. From Cluster Administrator, take the SQL Server resources off-line.
  3. Go to the node running SQL Server (see step 1) and start it from the command prompt using:

    sqlservr.exe -c -m

  4. Restore the master database using Query Analyzer or Enterprise Manager.
  5. Quit SQL Server from the command prompt.
  6. Using Cluster Administrator, restart the SQL Server services.

FROM SQL-Server-Performance.com

Consult us to explore the Databases. Contact us