Steps to Restore Master Database from a backup in clustered SQL Server 2005

Site sponsored by:

The gold standard of SQL Server performance monitoring & diagnostics

RSS Feeds

SQL Server Performance » SQL Server 2005 Forum Topics » SQL Server 2005 Clustering » Steps to Restore Master Database from a backup in clustered SQL Server 2005

Steps to Restore Master Database from a backup in clustered SQL Server 2005

Last post 11-26-2008 3:23 PM by satya. 4 replies.

Page 1 of 1 (5 items)
Active Topics My Discussions Unanswered	Sort Posts: Previous Next

11-24-2008 1:26 PM

gpreddy
Joined on 08-29-2008
Posts 16

Steps to Restore Master Database from a backup in clustered SQL Server 2005

Reply Contact

Hi,

Could you please provide me the steps to follow to restore the master database from an existing backup in Clustered SQL Server 2005?

Thanks in advance

11-25-2008 7:13 AM In reply to

ghemant
Joined on 03-23-2005
Pune, INDIA
Posts 2,277

Re: Steps to Restore Master Database from a backup in clustered SQL Server 2005

Reply Contact

Hi,

This link will help you http://www.sql-server-performance.com/faq/cluster_restore_master_database_p1.aspx

Regards

Hemantgiri S. Goswami
-------------------------
"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami

http://hemantgirisgoswami.blogspot.com
http://forums.surat-user-group.org/

Disclaimer: This post is provided as is, for the sake of knowledge sharing only.

Filed under: cluster, sql server 2005, restore master db, rebuild master database

11-25-2008 6:56 PM In reply to

gpreddy
Joined on 08-29-2008
Posts 16

Re: Steps to Restore Master Database from a backup in clustered SQL Server 2005

Reply Contact

Thank you

The link you given is for sql server 2000. Could you plz explain me the steps to restore master database in clustered SQL Server 2005 EE x64 on Windows 2003 R2 EE x64

11-26-2008 6:48 AM In reply to

ghemant
Joined on 03-23-2005
Pune, INDIA
Posts 2,277

Re: Steps to Restore Master Database from a backup in clustered SQL Server 2005

Reply Contact

I believe this will remain same for SQL Server 2005

Disclaimer: This post is provided as is, for the sake of knowledge sharing only.

Filed under: cluster, sql server 2005, restore master db, rebuild master database

11-26-2008 3:23 PM In reply to

satya
Joined on 11-05-2002
United Kingdom
Posts 22,747

Re: Steps to Restore Master Database from a backup in clustered SQL Server 2005

Reply Contact

I sense a problem here in moving the master database withina clustered enviornment, which must be performed on a controlled manner. Otherwise you will be risking the availablility of cluster as SQL service is dependant on the master datbase.

What Hemant referred still applicable and as it is SQL 2005 you can make use of SQLCMD:

Bring all the resources of the SQL Server Group in the cluster offline (except for Disk drive and IP Address).
Go to command prompt and start sql server using the following command sqlsrvr.exe -m (single user mode)
Connect to sqlcmd using ip address of the sql service sqlcmd -S xxx.xx.xx.xx (ip)

-Satya S K J

SQL Server MVP

Knowledge is Power, you will gain by sharing it. SSQA.net - Invisible contributions to the users & visible success in SQL Community.

Page 1 of 1 (5 items)

Active Topics My Discussions Unanswered Posts