Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Clustering / October 2006

Tip: Looking for answers? Try searching our database.

Restoring Master Database

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
RS - 20 Oct 2006 07:46 GMT
How can I restore master (SQL Server 2005) database on cluster environment?

Thanks in Advance.
Geoff N. Hiten - 20 Oct 2006 16:45 GMT
It works very similar to how it work on a stand-alone system, with a couple
of exceptions.

First, bring the SQL group to the node you are logged in to.
Using the Cluster Admin tool, stop the SQL Server Service.  Make sure the
disk, IP address, and network name resources stay online.

You can then follow the instructions on restoring a master database in BOL
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/c83d802c-e84e-4458-b3ca-173d9ba32f73.htm

Signature

Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

> How can I restore master (SQL Server 2005) database on cluster
> environment?
>
> Thanks in Advance.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.