• Perry Whittle (11/7/2013)


    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.

    Thanks Perry Whittle. I understand that, i need to run the wizard on passive node/server or do i need one more server for the third instance. and also is there any downtime for the existing cluster resource/server.

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/