Is Service Pack 2 completely installed on Passive Node of SQL Server 2012 Instance?
3
votes
1
answer
1949
views
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).
**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).
**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)?
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).
**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)?
Asked by EngineeringSQL
(579 rep)
Apr 25, 2015, 06:14 PM
Last activity: Mar 6, 2023, 12:00 PM
Last activity: Mar 6, 2023, 12:00 PM