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

          

Interview questions

SQL Server - restoring a master database on a SQL server cluster

Next>>         SQL Server tutorial  

SQL Server - restoring a master database on a SQL server cluster - Feb 27, 2010 at 11:50 AM by Shuchi Gauri

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

Steps to restore master database on SQL Server cluster:

  • Identify which node SQL Server is present on.
  • Use Cluster Administrator to take SQL Server resources off line.
  • Go to node running SQL Server from Step1 and start it from command prompt: sqlserver.exe –c –m
  • Restore master database through query analyzer or enterprise manager.
  • Quit SQL Server from command prompt.
  • Use Cluster Administrator to restart SQL Server services.

SQL Server - restoring a master database on a SQL server cluster - May 05, 2009 at 22:00 PM by Rajmeet Ghai

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

Restoring a master database on a SQL server cluster is required in case of a disaster when the previous backup is required. Ideally, restarting the server in single user mode can resolve this problem, however, not when the server is readily available. In scenarios like this, following steps can be followed:

  • The node on which the SQL server is running should be identified.
  • ALL the SQL server resources should be off-line using the cluster Admin.
  • Using the SQL server node above, from the command prompt, the following statement can be executed to start the server: sqlservr.exe -c –m
  • Query analyzer can be used to restore the master database.
  • The SQL server can now be quit from command prompt and the server services can be restarted using the Cluster admin.

SQL Server - restoring a master database on a SQL server cluster - June 21, 2009 at 09:00 AM by Amit Satpute

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

1. The node which the SQL Server is running on needs to be identified.

2. Then take the SQL Server resources off-line from Cluster Administrator.

3. Use sqlservr.exe -c –m command to run the SQL Server located at the node identified.

4. The master database can be restored using Query Analyzer or Enterprise Manager.

5. Exit the SQL Server.

6. Restart the SQL Server services using Cluster Administrator.


Next>>

Also read

Explain how to rebuild Master Database.

The Master database can be rebuilt using the following steps - The server should be shut down and Rebuildm.exe should be run..........

SQL Server system database

Master Database MSDB Database, TEMPDB Database, Model Database.........

Describe in brief system database.

Answer - Master database is system database. It contains information about server’s configuration. It is a very important database and important to backup Master.....

Describe in brief Databases and SQL Server Databases Architecture.

Answer - A database is a structured collection of data. Database can be thought as simple data file......

Sql Server DBA interview

What are the steps to take to improve performance of a poor performing query?
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?
What is blocking and how would you troubleshoot it?.............



Write your comment - Share Knowledge and Experience


 

 
Latest placement tests
Latest links
 
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring