Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Side-by-side instances of 2008R2 and 2012

Author  Topic 

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2013-06-09 : 17:11:55
Hi all,

I have a server with 2008R2 Enterprise.

I need an instance of 2012. Can I install 2012 on this same server without expecting some problems?

And if I decide to uninstall 2008R2 after installing 2012 ... will I be able to do that?

Thanks, Jack

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-06-10 : 08:07:46
you can, so far as OS,RAM etc match the prerequisites for 2012
You can uninstall 2008 R2 after that as its a separate instance

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2013-06-10 : 18:57:38
You might need to reboot, but there shouldn't be any issues. We have some clusters with SQL 2005 and 2012 installed, no issues.

Uninstalling might require a reboot too. Make sure you do any installations and uninstalls in a maintenance window to avoid unexpected downtime for your users.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2013-06-12 : 21:57:56
Thanks visakh16 and Tara!
Downtime would not be an issue as this is my server strictly used for DBA work.

I assume the 2012 instance would NOT have to be a named instance, is that correct? (The 2008 instance has the default, is not named)
Jack
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-06-13 : 00:51:31
quote:
Originally posted by jbates99

Thanks visakh16 and Tara!
Downtime would not be an issue as this is my server strictly used for DBA work.

I assume the 2012 instance would NOT have to be a named instance, is that correct? (The 2008 instance has the default, is not named)
Jack


nope..it has to be named if you're doing installation side by side with 2008 instance.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2013-06-14 : 14:27:42
quote:
Originally posted by jbates99

Thanks visakh16 and Tara!
Downtime would not be an issue as this is my server strictly used for DBA work.

I assume the 2012 instance would NOT have to be a named instance, is that correct? (The 2008 instance has the default, is not named)
Jack



You can only have one default instance per server. So if 2008 is already installed as the default instance, any new instances must be named, regardless of their version.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -