SQLServerCentral / SQL Server 2008 / SQL Server 2008 High Availability / difference between SQL Service pack patching in 2005 and 2008 Cluster evn / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 14:52:19 GMT20RE: difference between SQL Service pack patching in 2005 and 2008 Cluster evnhttp://www.sqlservercentral.com/Forums/Topic1403422-1549-1.aspx[quote][b]iamsam.sandeep (1/6/2013)[/b][hr]HI. Just wanted to know if there is any difference betwen Sql patching in 2005 and 2008 Cluster evn[/quote]Not just the patching but the installation of the product changed. You can however perform a rolling upgrade on SQL Server 2005 from SP3 onwards using the /PASSIVE switch.Mon, 07 Jan 2013 03:53:06 GMTPerry WhittleRE: difference between SQL Service pack patching in 2005 and 2008 Cluster evnhttp://www.sqlservercentral.com/Forums/Topic1403422-1549-1.aspxThanks. a lot for the responce.Mon, 07 Jan 2013 01:56:57 GMTiamsam.sandeepRE: difference between SQL Service pack patching in 2005 and 2008 Cluster evnhttp://www.sqlservercentral.com/Forums/Topic1403422-1549-1.aspxI believe so. In patching a SQL 2005 cluster you have to patch the active node of the cluster and the cluster updates all nodes at the same time.In SQL 2008 you patch the passive nodes first and then fail over SQL to an upgraded node before patching the last node. It reduces downtime this way.[url=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[/url]Mon, 07 Jan 2013 01:36:26 GMTJoie Andrewdifference between SQL Service pack patching in 2005 and 2008 Cluster evnhttp://www.sqlservercentral.com/Forums/Topic1403422-1549-1.aspxHI. Just wanted to know if there is any difference betwen Sql patching in 2005 and 2008 Cluster evnSun, 06 Jan 2013 23:41:35 GMTiamsam.sandeep