We need to add physical RAM to our SQL Server 2008 2-node cluster. Can we leave active node up and take down passive node to add the memory? Then we would failover to upgraded node and take down the newly passive node to add more memory.
Or should we down the whole thing and upgrade memory?
Shut down the passive node, upgrade, move SQL to it and test. If there are any adverse effects, or bad ram/etc, just fail it back and take the new ram out. If everything goes as planned, then upgrade the other node, fail back, and test again.