September 16, 2015 at 12:49 pm
We have a instance of SQL 2012 running on an Windows 2012 R2 Cluster. The passive node is off the network and not recognizing its NICs. Our hardware people are recommending a complete OS reinstall.
Evicting the non-viable node from Failover Cluster Manager is easy enough, but the documentation I'm reading calls for logging onto the node to be removed and running SQL Setup to remove the SQL node from the cluster.
Is this even necessary considering that the node is inaccessible via RDP and will be reformatted with a new OS install anyway? Or can I just evict it from the OS Cluster, and add it again once the new OS is installed & validated, followed with an "add to existing SQL cluster" SQL 2012 install?
September 17, 2015 at 7:08 am
dan-572483 (9/16/2015)
The passive node is off the network and not recognizing its NICs. Our hardware people are recommending a complete OS reinstall.
seems a bit drastic, doesn't seem like they have put much effort into resolving the NIC problem, what's a fresh install going to prove.
This should be fairly easy to resolve I think
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 17, 2015 at 9:52 am
This was just passed to me yesterday. My part would be to do the SQL part of rebuilding the cluster node once the OS is reinstalled. Apparently the hardware guy has tried a bunch of things already, but I don't know the details of what.
September 17, 2015 at 10:13 am
dan-572483 (9/17/2015)
This was just passed to me yesterday. My part would be to do the SQL part of rebuilding the cluster node once the OS is reinstalled. Apparently the hardware guy has tried a bunch of things already, but I don't know the details of what.
I've had NIC issues on cluster nodes before and nearly always solved by getting the latest drivers. Ask him exactly what he's tried.
You can evict the node but ideal if it doesn't come back as the same name.
Fix the NIC issue, I fail to see what an OS rebuild is going to provide, if its software issue, uninstall then reinstall the drivers
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply