DBA in Unit 7 (1/8/2013)
One node in our cluster had a hardware failure and comepletely down and need to rebuild. I am asking for advices/suggestions to get back the node and the cluster working.1.the OS is Windows 2008 R2 Enterprises
2.SQL version is SQL 2008
They are asking if we want to
a) completely rebuild the server ---if we go down this path, what do i need to do to get the SQL cluster working
b) restore the server from an earlier backup--Will this restore mess up the SQL Cluster settings or functions?
Please advise...thank you in advance
How recent is the system state backup of the failed node?
If you dont have a recent backup i would evict the failed node and perform a clean OS install to the new hardware. Add the node to the cluster and then re install any clustered applications.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉