• spaghettidba (2/24/2015)


    Perry Whittle (2/24/2015)


    do not evict the node, this is not the correct action.

    Why wouldn't it work? I'm pretty sure I have done this in the past.

    I'm not trolling you, Perry, I really want to know if there's something I'm overlooking.

    I didn't say it wouldn't work 😉

    Eviction is generally the last ditch at removing a node.

    spaghettidba (2/24/2015)


    Perry Whittle (2/24/2015)The restriction on how many nodes may host a clustered instance of SQL Server in Standard edition is within the SQL Server setup itself not the Windows Server Failover Cluster.

    It is perfectly valid to have 3 nodes in the WSFC and only install a standard edition instance to 2 of these nodes.

    • Join the new node to the cluster this will make a 3 node cluster
    • run the remove node wizard on the server being replaced, the instance will be installed on the one remaining original node
    • Run the add node wizard on the new cluster node, this will make the instance available on 2 nodes again

    Does this make sense?

    Great points as usual. You're the go-to person for this stuff.

    Thank you :blush:

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

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