locked
Question about updating SQL Server on failover cluster RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi all,

    I would like to better understand the update process of SQL Server (2008 r2) in a failover cluster environment.

    In our cluster we have 4 instances of SQL running, where two of them I am able to at anytime stop the instance and update it.

    The question is... Applying the latest update, will update forcibly all instances installed on that node, or do I have the ability to choose which instance I want to update?

    This way, I could "test" the update process in those two SQL Instances, as described in http://support.microsoft.com/kb/958734 and after finishing I would update the remaining instances.

    Please let me know.

    Thanks in advance.

    Nuno Silva


    Tuesday, November 4, 2014 12:58 PM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    Hello,

    With clustering, you'll want to use the rolling patch method. Patching the inactive instances first (regardless of node) and eventually having an outage to swap services.

    Yes, you can choose which instances the patches are installed to.

    -Sean

    The views, opinions, and posts do not reflect those of my company and are solely my own. No warranty, service, or results are expressed or implied.

    Thursday, November 6, 2014 1:42 AM
    Answerer

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Nuno,

    It's a failover cluster issue, I moved it to SQL Server High Availability and Disaster Recovery. So that you can get better help.

    Regards,

    Charlie Liao
    TechNet Community Support

    Thursday, November 6, 2014 1:10 AM
  • Question
    Sign in to vote
    1
    Sign in to vote

    Hello,

    With clustering, you'll want to use the rolling patch method. Patching the inactive instances first (regardless of node) and eventually having an outage to swap services.

    Yes, you can choose which instances the patches are installed to.

    -Sean

    The views, opinions, and posts do not reflect those of my company and are solely my own. No warranty, service, or results are expressed or implied.

    Thursday, November 6, 2014 1:42 AM
    Answerer