Adding a new Node on the existing SQL Server two nodes cluster.

  • I currently have a two nodes SQL Server cluster. Both nodes have identical hardware (dell R900 servers). I want to add a third node on the existing cluster, is that possible? another concerned is; the server for the third node is not identical to the initial two existing nodes. Will this work or will it face issues?

    Thank you in advance.

  • you can add another node. It should work. But you should make sure your third node can handle your sql instance(s) in case of failover.

  • soccer (8/7/2012)


    I currently have a two nodes SQL Server cluster. Both nodes have identical hardware (dell R900 servers). I want to add a third node on the existing cluster, is that possible? another concerned is; the server for the third node is not identical to the initial two existing nodes. Will this work or will it face issues?

    Thank you in advance.

    What edition of SQL server are you using, if it's standard then you can't install to a third node the limit is 2.

    It's not ideal to have different spec nodes but can be done, this usually happens when you cluster a physical node with a virtual node.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • I have SQL 2008 enterprise edition.

  • In that case a third node is possible

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • How you tried this... was this worked fine?

  • It worked, thanks.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply