Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Availability Groups and DR (2012)
 Understanding Sql Failover Clustering

Author  Topic 

srm
Starting Member

8 Posts

Posted - 2014-12-11 : 10:22:28
Hello Everyone,
I am fresher to windows clustering and doing sql clustering first time.
I am doing windows clustering on vmware for two node cluster and san storage is iscsitarget software downloaded from net.
Now I was able to sucessfuly configure windows cluster on windows server 2008 R2,I would like to know before doing sql clustering on it.
When I install Sql on node1 which is on cluster,I require to restart my
vm machine(i.e Node1) after installing Sql server 2012 ent edition.
Now in that case my windows cluster would failover,then What should I do
to resolve this problem.
Do I need to stop windows cluster while installing Sql on clustered node?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-12-11 : 12:29:34
I always perform a restart when installing SQL Server. Sometimes it won't be required until after you install the service pack, but I do it even if it doesn't mention it.

You do not need to and should not stop the Windows cluster.

You will need to install SQL on both nodes, the second node will be using the "add a node" option.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

srm
Starting Member

8 Posts

Posted - 2014-12-11 : 13:02:44
quote:
Originally posted by tkizer

I always perform a restart when installing SQL Server. Sometimes it won't be required until after you install the service pack, but I do it even if it doesn't mention it.

You do not need to and should not stop the Windows cluster.

You will need to install SQL on both nodes, the second node will be using the "add a node" option.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/



Well,I believe you can also install through Advanced option from Installation media from Advance Cluster Preparation on both nodes and then using Advanced Cluster Completion on any one node where clustering is created.But in any case after Sql installation you need to restart the machine(vmware in my case)then it would affect windows cluster that is running on one the nodes as it will not be available that might start failover am I right??
Go to Top of Page

srm
Starting Member

8 Posts

Posted - 2014-12-11 : 13:05:37
Could please me the steps what I need to do?
I have two node windows cluster on vmware with third machine acting as a DC with SAN storage created with iscsi target and initialtor.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-12-11 : 13:50:17
Yes if you restart a node and if it was hosting any cluster resources, then those cluster resources will be failed over to the other node.

What other cluster resources do you have?

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

srm
Starting Member

8 Posts

Posted - 2015-01-06 : 03:46:46
Hi I have only Sql Server 2012 on my cluster,no other resource.So How do Stop/shutdown windows cluster gracefully so it will not fail on my vmware..
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2015-01-06 : 12:01:22
Why are you stopping/shutting down the windows cluster? All you need to do is perform a failover so that one node is active and the other is passive. You can perform work on the passive node without impacting the active node.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -