upgrade existing sql 2008 sp2 named instance to sql 2008 r2?

  • There are a default instance and 2 named instance in our sql cluster; they are both running sql 2008 sp2. One of customer want to upgrade one of the named instance from sql 2008 sp2 to sql 2008 r2.

    So, the sql cluster will be:

    1. default instance - sql 2008 sp2

    2. 1st named instance - sql 2008 r2

    3. 2rd named instance - sql 2008 sp2

    Is it possible? how to archive it?

  • its possible, but i'd go through it on a test system first if i were you to avoid hosing the production systems. Theres quite a bit to do here and not some thing that can be laid down in a forum post. Do you have any experience with MSCS or SQL server installations?

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

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

  • Sure, i post it in the forum because I want some idea from sql expert.

    Found an URL http://msdn.microsoft.com/en-us/library/ee210714.aspx; it is possible to have different version of sql within sql server.

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

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