muthukkumaran Kaliyamoorthy (11/7/2013)
I have a 2 node cluster (2-physical servers) “instance1” is passive for “instance2” & “instance2” is passive for "instance1" vice versa.I want to add/install 3rd SQL “instance3”. No test server to test, I hope it’s just an --> Add node to a SQL server fail-over cluster. Any suggestion or prerequisites.
SQL and Windows = 2008 R2
Thanks for your help.
You'll need to present shared storage to the nodes for the new instance and set the new disks up as cluster resources, once done you can run the wizard on one node and create a new failover clustered instance, then run the add node wizard on the remaining node.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉