Post reply

Upgrade one SQL Server Instance on a multiple instance Environment?

  • 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

  • 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" 😉

Viewing 2 posts - 1 through 1 (of 1 total)

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