apply a service pack or hotfix sql server 2008 to a failover cluster instance - microsoft sql server...
DESCRIPTION
apply serviceTRANSCRIPT
-
5/21/2018 Apply a Service Pack or Hotfix SQL Server 2008 to a Failover Cluster Instance - Micr...
http:///reader/full/apply-a-service-pack-or-hotfix-sql-server-2008-to-a-failover-cl
7/24/2014 Apply a service pack or hotfix SQL Server 2008 to a failover cluster instance - Microsoft SQL Server - Site Home - TechNet Blogs
http://blogs.technet.com/b/mdegre/archive/2010/01/16/apply-a-sql-server-2008-service-pack-or-hotfix-to-a-failover-cluster-instance.aspx
Apply a service pack or hotfix SQL Server 2008 to a failover cluster
instance
8Degremont Michel 16 Jan 2010 3:40 PM
Apply a service pack or patch SQL Server 2008 in a clustered environment
Step 1 : Validation wizard
Step 2 : Pre-check
Step 3 : Installation of the first node
Step 4 : Add a new node
Step 5: Apply a service pack or hotfix on a SQL cluster
Installing Service Pack SQL Server 2008 in failover cluster is very different than the SQL Server 2005 cluster failover.
With SQL Server 2005, when you start installing cluster service pack (or hotfix), 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 hotfix), 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 failover cluster, you must follow the scenario below for the application of Service
Pack, Cumulative Update or Hotfix :
1. Apply the hotfix on pasive node N2
2. Reboot the passive node N2
3. Failover on SQL resource : the passive node become the active node
4. Apply the hotfix on the passive node N1
5. Reboot the passive node N1
You can check the version of SQL server with the following query:
SELECT
SERVERPROPERTY('IsClustered')as_1_Means_Clustered ,
SERVERPROPERTY('Edition')asEdition ,
SERVERPROPERTY('ProductVersion')asVersion ,
SERVERPROPERTY('ComputerNamePhysicalNetBIOS')asActiveNode
http://blogs.technet.com/mdegre/archive/2009/12/28/installation-of-sql-server-2008-clusters-on-windows-2008-step-2-pre-check.aspx?ushttp://blogs.technet.com/mdegre/archive/2009/12/25/apply-a-sql-server-2008-service-pack-or-hotfix-to-a-failover-cluster-instance.aspx?frhttp://blogs.technet.com/mdegre/archive/2009/12/25/apply-a-sql-server-2008-service-pack-or-hotfix-to-a-failover-cluster-instance.aspx?eshttp://blogs.technet.com/mdegre/archive/2009/12/25/apply-a-sql-server-2008-service-pack-or-hotfix-to-a-failover-cluster-instance.aspx?ushttp://blogs.technet.com/mdegre/archive/2009/12/29/installation-of-sql-server-2008-clusters-on-windows-2008-step-4-add-a-new-node.aspx?ushttp://blogs.technet.com/mdegre/archive/2009/12/28/installation-of-sql-server-2008-clusters-on-windows-2008-step-3-installation-of-the-first-node.aspx?ushttp://blogs.technet.com/mdegre/archive/2009/12/28/installation-of-sql-server-2008-clusters-on-windows-2008-step-2-pre-check.aspx?ushttp://blogs.technet.com/mdegre/archive/2009/12/25/installation-of-sql-server-2008-clusters-on-windows-2008-step-1-validation-validation-wizard.aspxhttp://blogs.technet.com/mdegre/archive/2009/12/25/apply-a-sql-server-2008-service-pack-or-hotfix-to-a-failover-cluster-instance.aspx?ushttp://blogs.technet.com/mdegre/archive/2009/12/25/apply-a-sql-server-2008-service-pack-or-hotfix-to-a-failover-cluster-instance.aspx?eshttp://blogs.technet.com/mdegre/archive/2009/12/25/apply-a-sql-server-2008-service-pack-or-hotfix-to-a-failover-cluster-instance.aspx?frhttp://social.technet.microsoft.com/profile/Degremont%20%20Michelhttp://-/?- -
5/21/2018 Apply a Service Pack or Hotfix SQL Server 2008 to a Failover Cluster Instance - Micr...
http:///reader/full/apply-a-service-pack-or-hotfix-sql-server-2008-to-a-failover-cl
7/24/2014 Apply a service pack or hotfix SQL Server 2008 to a failover cluster instance - Microsoft SQL Server - Site Home - TechNet Blogs
http://blogs.technet.com/b/mdegre/archive/2010/01/16/apply-a-sql-server-2008-service-pack-or-hotfix-to-a-failover-cluster-instance.aspx
SQL Server 2008 failover cluster rolling patch and service pack process
http://support.microsoft.com/kb/958734
How to update or slipstream an installation of SQL Server 2008
http://support.microsoft.com/kb/955392
Michel Degremont | Microsoft EMEA
Product Support Services Developer - SQL Server Core Engineer |
Comments
Deepti 11 Oct 2010 11:34 AM
Thanks a Ton for simplifying the process of Installing the SQL 2008 Service Pack, since it is different in both 2005 and
2008. I now understand the difference!
Nicolaas 9 May 2011 10:33 AM
Hi Michel, thanks for the information, 2008 seems much more simpler, but I just wanted to check one thing - do you
have to make any cluster modification to the cluster, i.e. remove the passive node from the active\passive fail-over
cluster and the list of possible network resource owners, before you patch it?
Parthik Parikh26 Oct 2011 8:54 PM
Does anyone know how internally services will be updated? I mean to say, if we are installing Service Pack 3 on SQL
server 2008 Passive node (Without removing that node from cluster according to this article), what would be installed
on that passive node. As per I know there won't be any SQL server services to update on that node, eventhough if we
would have client tool, it should update only new features related to the installed tools. So how would the services will
http://social.technet.microsoft.com/profile/Parthik%20Parikhhttp://support.microsoft.com/kb/955392http://support.microsoft.com/kb/958734 -
5/21/2018 Apply a Service Pack or Hotfix SQL Server 2008 to a Failover Cluster Instance - Micr...
http:///reader/full/apply-a-service-pack-or-hotfix-sql-server-2008-to-a-failover-cl
7/24/2014 Apply a service pack or hotfix SQL Server 2008 to a failover cluster instance - Microsoft SQL Server - Site Home - TechNet Blogs
http://blogs.technet.com/b/mdegre/archive/2010/01/16/apply-a-sql-server-2008-service-pack-or-hotfix-to-a-failover-cluster-instance.aspx
be updated? I am comparing it to SQL 2K5, that when we do update on active node, it will update the database
engine service on that node.So, SQL 2k8 come up with separate update for database engine service irrelevant of
nodes? That means if we failover to Passive, DB Engine or Server automatically runs under SP3? and similar thing we
can do with Active?
Please clarify.
Thanks,
Parthik
Degremont Michel6 Nov 2011 7:20 PM
Hi
SQL 2005 and 2008 are really different regarding the cluster installation.
With SQL 2005, the setup will install in silence on a ll nodes.
But with 2008 you have to run the SP on each node. The SP will first update the binaries files. Then when you will
failover on the passive node, during the startup a script will be run. If you have a look inside SQL Serve error log, you
will see some information about this script.
I confirm you that you dont need to remove any node during the setup of SP.
Cheers,
Michel.
Mark 21 Nov 2011 5:06 PM
What if it is and Active\Active cluster?
Degremont Michel4 Dec 2011 1:00 PM
Hi Mark,
SQL Server Failover is an Active/Passive cluster.
When someone says Active/active for SQL Server, that means 2 instances are hosted by the cluster. First instance is on
the fist node, and the second one, on the second node.
Yuval 30 Jan 2012 11:59 AM
Attached the offical installation procedure:
support.microsoft.com/.../958734
Prashant Deshpande 21 Aug 2013 11:38 AM
Lovely Document, cleared the Setup idea
http://support.microsoft.com/kb/958734http://social.technet.microsoft.com/profile/Degremont%20%20Michelhttp://social.technet.microsoft.com/profile/Degremont%20%20Michel