dbTalk Databases Forums  

Re-Installing A Clustered Node For SQL 2008

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss Re-Installing A Clustered Node For SQL 2008 in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
tom
 
Posts: n/a

Default Re-Installing A Clustered Node For SQL 2008 - 04-15-2010 , 07:09 PM






I have a 2 node active/passive cluster running SQL2008 with SP1.

Installation was performed by command line script using a config file.
Started with 1st node with /action = "InstallFailoverCluster". Second node
was installed with a diff config file using the /action= "Add Node". Cluster
operational for over 6 months.

Node 1 has had a hardware failure requiring a re-install of OS and SQL. The
Instance which is also a production instance is now running on second node.

What /action parameter do I use(INSTALLFAILOVERCLUSTER or ADDNODE or
something else) to re-install SQL on the rebuilt node? Will the re-install
have any impact on the second node which is running prod?

Reply With Quote
  #2  
Old   
Charles Wang [MSFT]
 
Posts: n/a

Default RE: Re-Installing A Clustered Node For SQL 2008 - 04-19-2010 , 08:29 AM






Hi Tom,
This is a common encountered scenario. Before you add node to your cluster,
please first make sure that your installed OS and SQL Server 2008 instance
have same versions as your original passive node but now active node.

Then after you add the node to the windows cluster, you can refer to the
following article to re-add the node to the existing cluster:
How to: Add or Remove Nodes in a SQL Server Failover Cluster (Setup)
http://msdn.microsoft.com/en-us/library/ms191545.aspx

For command line, you can refer to the following:
setup.exe /q /ACTION=AddNode /INSTANCENAME="<Insert Instance Name>"
/SQLSVCACCOUNT="<SQL account that is used on other nodes>"
/SQLSVCPASSWORD="<password for SQL account>" /AGTSVCACCOUNT="<SQL Server
Agent account that is used on other nodes>", /AGTSVCPASSWORD="<SQL Server
Agent account password>" /INDICATEPROGRESS

More information can be found
here,http://technet.microsoft.com/en-us/l...9.aspx#AddNode.

Best regards,
Charles Wang

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.