Patching Clustered Instances

Last post 10-07-2008 3:10 PM by eersonmez. 2 replies.
Page 1 of 1 (3 items)
Active Topics My Discussions Unanswered Sort Posts: Previous Next
  • 10-07-2008 12:55 PM

    Patching Clustered Instances

    Is there a way to patch a clustered SQL Server 2005 instance running on two physical hosts without any downtime (or just the downtime during a cluster failover)? 

     I'm asking this because my DBA claims the clustered instance cannot be available (on either host) during SQL Server patching, which will take about 20-30 minutes.  However, I thought that was the whole point of clustering -- one of the cluster instances will be active while the other is down for some reason (hardware, network, and even patching?). 

     Any guidance is much appreciated.

  • 10-07-2008 1:28 PM In reply to

    Re: Patching Clustered Instances

    Your DBA is right, there is no way you can apply service pack without downtime.

    Make sure you apply the SP on both nodes.

    High availability only incase of server hardware failure not the SAN failure and software upgrades Smile

    MohammedU.
    Microsoft SQL Server MVP
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  • 10-07-2008 3:10 PM In reply to

    Re: Patching Clustered Instances

    Thanks for the quick response.  We will think about setting up database mirroring between this 2-node clustered instance and another instance. 

    This might be a stupid question but can we mirror databases to another clustered instance running on the same 2 nodes?  I realize that might lead to a situation where both the mirror and the principal instances are running on the same node.  Not sure if that's possible... 

     

Page 1 of 1 (3 items)
Active Topics   My Discussions    Unanswered Posts


© 2000 - 2007 vDerivatives Limited All Rights Reserved.