We have a clustered SQL server (2k5 Std) that's currently being hosted on 1 of 2 subnets on the server. We'd like to retire the subnet the SQL cluster is on as we're experiencing default gateway issues with the servers being multi-homed.
My question is what is the best way to migrate the SQL cluster from one network to the other? It would reside in the same cluster, same name, just dependent on another subnet.
My instinct tells me to just reinstall sql into the cluster, specifying the other subnet on the install, then clean up the mess afterwards.
But I was wondering if maybe there was any other ways, perhaps a best practice that I'm not aware of.