October 24, 2016 at 1:32 pm
I need to apply Service Pack 3 in SQL 2012\Windows 2012 R2 server. Its Active\Passive node. Do I need to remove the passive node from the "Possible Owner" before applying Service pack? All I know is its not needed since the Windows 2012 R2 Failover cluster will be aware SP3 is being applied to the passive node and it will not initiate a failover to the passive node rather it will remains in Active node incase of any issue. Could some one clarify please...
October 24, 2016 at 2:59 pm
In a 2 node cluster you could get by most likely, I have done this without issue before. But why wouldn't you take the 20 seconds to eliminate the possibility of something going wrong?
October 26, 2016 at 10:44 am
saravanan.thamidurai (10/24/2016)
I need to apply Service Pack 3 in SQL 2012\Windows 2012 R2 server. Its Active\Passive node. Do I need to remove the passive node from the "Possible Owner" before applying Service pack? All I know is its not needed since the Windows 2012 R2 Failover cluster will be aware SP3 is being applied to the passive node and it will not initiate a failover to the passive node rather it will remains in Active node incase of any issue. Could some one clarify please...
You remove the node as a possible owner from the networkname resource only and then add it back again once the SP has been completed.
WSFC subsystem checks the networkname for a sql server cluster role to determine the possible failover nodes
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply