Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

difference between SQL Service pack patching in 2005 and 2008 Cluster evn Expand / Collapse
Author
Message
Posted Sunday, January 6, 2013 11:41 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, July 25, 2013 4:07 AM
Points: 97, Visits: 124
HI.

Just wanted to know if there is any difference betwen Sql patching in 2005 and 2008 Cluster evn
Post #1403422
Posted Monday, January 7, 2013 1:36 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: 2 days ago @ 7:28 AM
Points: 709, Visits: 1,417
I 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.

Apply a service pack or hotfix SQL Server 2008 to a failover cluster instance


Joie Andrew
"Since 1982"
Post #1403469
Posted Monday, January 7, 2013 1:56 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, July 25, 2013 4:07 AM
Points: 97, Visits: 124
Thanks. a lot for the responce.
Post #1403478
Posted Monday, January 7, 2013 3:53 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:56 AM
Points: 6,288, Visits: 13,546
iamsam.sandeep (1/6/2013)
HI.

Just wanted to know if there is any difference betwen Sql patching in 2005 and 2008 Cluster evn

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.


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1403524
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse