I've got a 2-node SQL Server cluster (SQL 2008 sp1) running on Windows Server 2008 R2. It's an active/passive cluster and currently, node1 is the active node.
There is an app running on node1.
I've got a requirement to put another app on the cluster. however, due to resource usage, i've been asked if node2 can be the active node for this new app.
Is this possible?? If so, do I just create a new SQL cluster, using node2 as the active app as normal??