We are applying SQL Server 2012 Service Pack 2 (SP2) to a two-node active/passive cluster, starting with the passive node (as per best practices):
- How to install a Service Pack at a SQL Server 2012 Failover Instance: Best Practices (http://blogs.msdn.com/b/john_daskalakis/archive/2014/09/05/how-to-install-a-service-pack-at-a-sql-server-2012-failover-instance-best-practices.aspx)
Applying SP2 to the passive node produced a result indicating four installation failures (as per FIGURE 1).
When we begin to re-apply SP2, we can see that the Build Number is correct and the Upgrade Status is "Incompletely Installed" (as per FIGURE 2).
AND SO THE QUESTION: Will the passive node remain in an Incompletely Installed upgrade status until the active node is failed over to the passive (making the passive node ACTIVE)?