Difference between SQL patching in 2005 and 2008 Cluster environment
Installing Service Pack SQL Server 2008 in fail over cluster is very different than the SQL Server 2005 cluster failover.
With SQL Server 2005, when you start installing cluster service pack (or hot fix), it must be launched on the active node (node that hosts the instance). When installing the Setup will launch simultaneously “remote silence” on all passive nodes. All nodes in the cluster containing the SQL Server instance are updated in the same time.
With SQL Server 2008, to reduce the downtime, we have revised the method of deployment. Now if you want to apply a service pack (or hot fix), you must install in first on the passive nodes. The passive nodes are updated before the active node.
Therefore, for your instance SQL Server 2008 in fail over cluster, you must follow the scenario below for the application of Service Pack, Cumulative Update or Hot fix :
1. Apply the hot fix on passive node N 2
2. Reboot the passive node N 2
3. Fail over on SQL resource : the passive node become the active node
4. Apply the hot fix on the passive node N 1
5. Reboot the passive node N 1
2. Reboot the passive node N 2
3. Fail over on SQL resource : the passive node become the active node
4. Apply the hot fix on the passive node N 1
5. Reboot the passive node N 1
| RTM (no SP) | SP1 | SP2 | SP3 | SP4 | |
|---|---|---|---|---|---|
 SQL Server 2017codename vNext | not yet released | ||||
| SQL Server 2016 | 13.0.1601.5 | 13.0.4001.0 or 13.1.4001.0 | |||
| SQL Server 2014 | 12.0.2000.8 | 12.0.4100.1 or 12.1.4100.1 | 12.0.5000.0 or 12.2.5000.0 | ||
| SQL Server 2012 codename Denali | 11.0.2100.60 | 11.0.3000.0 or 11.1.3000.0 | 11.0.5058.0 or 11.2.5058.0 | 11.0.6020.0 or 11.3.6020.0 | will be released in June 2017 |
| SQL Server 2008 R2 codename Kilimanjaro | 10.50.1600.1 | 10.50.2500.0 or 10.51.2500.0 | 10.50.4000.0 or 10.52.4000.0 | 10.50.6000.34 or 10.53.6000.34 | |
| SQL Server 2008 codename Katmai | 10.0.1600.22 | 10.0.2531.0 or 10.1.2531.0 | 10.0.4000.0 or 10.2.4000.0 | 10.0.5500.0 or 10.3.5500.0 | 10.0.6000.29 or 10.4.6000.29 |
| SQL Server 2005 codename Yukon | 9.0.1399.06 | 9.0.2047 | 9.0.3042 | 9.0.4035 | 9.0.5000 |
| SQL Server 2000 codename Shiloh | 8.0.194 | 8.0.384 | 8.0.532 | 8.0.760 | 8.0.2039 |
| SQL Server 7.0 codename Sphinx | 7.0.623 | 7.0.699 | 7.0.842 | 7.0.961 | 7.0.1063 |
No comments:
Post a Comment