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" 😉