I'm looking into building a shared SQL environment using two servers as a 2-node Active/Active cluster, and attached to a NetApp SAN. I'm planning on installing SQL Server 2008 R2 on Windows Server 2008 R2 64-bit.
My question is the following: Let's suppose I have 2 SQL Server instances per server/node (4 in total). If I want to add a third by adding new LUNs to the cluster... do I have to bring down the rest of the SQL Server instances on the same node? Or is that something that can be done on the fly without having to bounce the rest of the instances? (I know I do have to bounce SSIS)
Thanks in advance for any tip!