Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have been using SQL Server 2008 R2 for quite a while, and it is working great. Now I need to use SQL Server 2012. Will this effect my existing databases? How much risk is involved in installing SQL Server 2012 on a machine that has SQL Server 2008 R2 running?

share|improve this question
1  
superuser.com/questions/402785/… –  bummi Jun 5 '13 at 8:18
    
Thanks @bummi... –  user960567 Jun 5 '13 at 8:40
add comment

2 Answers

up vote 5 down vote accepted

You can simply install a new, named instance, and the two instances can live side-by-side with no risk - just be sure that your connections strings etc. are clear and correct (many problems arise from connecting to LOCALHOST when you meant to connect to LOCALHOST\OtherInstance).

Depending on resources you may want to be sure to cap both servers using the max server memory configuration option, or perhaps even only running one instance at a time. I assume this is on your local development environment.

I'd suggest abandoning the 2008 R2 version of the client tools and using the 2012 version consistently. It has much better functionality and can manage both versions seamlessly.

share|improve this answer
3  
+1 Here's also a lot of great considerations for side-by-side instances, and depending on what the major and minor versions it'll point out shared items and possible contention. SQL Server 2012 isn't mentioned, but the ideas remain the same: technet.microsoft.com/en-us/library/ee210714(v=SQL.105).aspx –  Thomas Stringer Jun 5 '13 at 12:35
    
Thanks.......... –  user960567 Jun 5 '13 at 12:50
    
@ThomasStringer good point. We had a lot of issues with 2005/2008 side by side using shared features. –  Cougar9000 Jun 5 '13 at 14:59
add comment

Generally yes. Your services on 2008 R2 will continue running normally unless you manually make some changes.

Only impact that sql 2012 can have is if you plan to run some performance intensive operations but nothing else apart from that.

Here is a good article on MSDN on site-by-side support for different versions of SQL Server http://msdn.microsoft.com/en-us/library/ms143694.aspx

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.