Update single SQL instance to 2012

  • I have a single 2008R2 windows server with 9 SQL 2008R2 standard instances install. This server is also setup as a three node failover cluster. Two SQL and one witness. I need to in line update only one of the instances to SQL 2012. Has anybody have any experience in doing this? Am I able to do this without affecting any of the other SQL instances?

  • Joshua D Gang (9/10/2015)


    I have a single 2008R2 windows server with 9 SQL 2008R2 standard instances install. This server is also setup as a three node failover cluster. Two SQL and one witness. I need to in line update only one of the instances to SQL 2012. Has anybody have any experience in doing this? Am I able to do this without affecting any of the other SQL instances?

    First thought is doing a separate install of 2012 and then migrate the data from the 2008, least interference and a clear fallback path.

    😎

  • Yes that was my first thought as well, getting pushback from my System Admin. Just need to make a good enough case to have this happen.

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

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