Home Forums SQL Server 2008 SQL Server 2008 High Availability difference between SQL Service pack patching in 2005 and 2008 Cluster evn RE: difference between SQL Service pack 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"