Post reply

SQL Server 2008 Cluster updating

  • June 27, 2011 at 7:00 pm

    #389847

    Guys and Girls. I have a SQL Server 2008 cluster. I want to update it to 2008 SP2. Is it just a matter of updating each instance separately? Would love to read some articles on what is required. My thinking is upgrade the server not currently in use, fail the other server over and then upgrade the other server. Should be no issues with the database as its all 2008. Would love some confirmation on this.

    Brian

  • June 28, 2011 at 1:26 am

    #1344984

    You appear to have stumbled on best practice.

    1. Apply SP to passive node

    2. Failover cluster

    3. Apply SP to passive node

  • June 28, 2011 at 2:40 am

    #1345010

    Agreed

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

  • June 29, 2011 at 5:57 am

    #1345830

    I have done this several times in that order. Make sure you make backups of master, model, msdb and an app dbs before you apply SP2 as a just in case.

  • June 29, 2011 at 6:32 am

    #1345859

    Also, you shouldnt attempt to fail back until you applied the update to the second node as the binaries and databases will be of differing versions.

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

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