Upgrade one SQL Server Instance on a multiple instance Environment?

• HookSQLDBA7

  SSChampion

  Points: 10709

  More actions

  February 29, 2012 at 8:05 am

  #391683

  We are running multiple (3 or 4) instances of SQL Server 2005 SP3 (EE) 64-Bit on one server. I would like to know if it is possible to upgrade one of these instances to SQL Server 2008 without affecting the other instances? Or, does all instances have to be upgraded at the same time? (Does the instances share some common files?)

  If possible, what would be the best method to use to upgrade one instance?

  Thanks in advance, Kevin

• Perry Whittle

  SSC Guru

  Points: 234040

  More actions

  February 29, 2012 at 4:29 pm

  #1453419

  yes you can upgrade individual instances, if you run the GUI version of the service pack you will see the appropriate checkboxes for each instance. If patching from the command line you need to use the /INSTANCENAME parameter

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs"