Post reply

Installing SP1 on SQL Server 2008 Cluster

  • January 7, 2010 at 8:58 am

    #386057

    Hi,

    I want to install SP1 on SQL Server 2008 Cluster (Windows 2003 as OS). The procedure seems to be straight forward. Briefly, first installing on passive node after than move groups and installing again on passive node. My question is, what happens with updates that SQL server must do in system tables as master, msdb, model if, of course, updates are necessary, since the passive node is not owner of the SQL Server databases, the active node is the owner, right? How updates to these system tables are done in this case? Same question for installing last Cumulative Updates for SQL Server 2008.

    Thanks in advance.

  • January 7, 2010 at 10:37 pm

    #1100691

    Those items will be updated when you failover and that node becomes the active one.


    Shamless self promotion - read my blog http://sirsql.net

  • January 8, 2010 at 9:53 am

    #1101017

    Thanks for your answer. Seems to be logic. What happens if I install SP1 on the passive node (once the active that was passive has SP1 installed, so master, msdb, etc. is also updated) and I failover after on this one, the installation of SP1 will try to update again the system tables or it will recognize that the SP1 is already installed on SQL Cluster? I would like to know just by curiosity.

    Thanks again.

  • January 8, 2010 at 9:58 am

    #1101023

    It will recognize that the system information is up to date and so will not attempt to perform other changes.


    Shamless self promotion - read my blog http://sirsql.net

  • January 8, 2010 at 11:36 am

    #1101103

    Thank you again.

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

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