Post reply

difference between SQL Service pack patching in 2005 and 2008 Cluster evn

  • January 6, 2013 at 11:41 pm

    #393880

    HI.

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

  • January 7, 2013 at 1:36 am

    #1574197

    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"

  • January 7, 2013 at 1:56 am

    #1574205

    Thanks. a lot for the responce.

  • January 7, 2013 at 3:53 am

    #1574242

    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" 😉

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply