Very simple issue. In case of hardware unrecoverable issue, I have two msdn articles which states different things.
First one claims you remove the node from mscs. https://msdn.microsoft.com/en-us/library/ms181075(v=sql.100).aspx
Second one claims you should remove it using sql server installation and links to the first link which says you should do it from mscs: https://msdn.microsoft.com/en-us/library/ms189117(v=sql.100).aspx
Then this third article invalidates the second article. "To remove a node from an existing SQL Server failover cluster, you must run SQL Server Setup on the node that is to be removed from the SQL Server failover cluster instance." https://msdn.microsoft.com/en-us/library/ms191545(v=sql.100).aspx#Remove. It is a hardware faillure where the secondary node is innaccessible.
So what is the proper way to evict a node you cannot access due to a hardware faillure?note: I don't plan on adding back the failed nodes after removing it. i.e. I am insterested in the removing part.
- Edited by Antoine F Monday, July 20, 2015 8:31 PM