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've upgraded my SQL Server from the 2008 R2 Express edition to a full standard version of SQL Server 2014. Now I'm running them both side by side. But my problem is how can I abandon the 2008 version and only run on the 2014 version? I've check the properties on the SQL Server 2014, and it shows that I'm still with 2008 R2 Express edition. How is that possible?

share|improve this question
    
Are you actually connecting to the 2014 instance? In saying that you've checked the properties, and it's reporting 2008 R2 Express, I suspect you're not looking at what you think you're looking at. What's the instance name for 2014? It would be different from the 2008 R2 instance, and needs to be specified in your connection. I would have added all this as a comment, but don't have enough reputation to comment. –  BlueRebel May 22 at 14:17

2 Answers 2

Now i'm running them both side by side

So, to clarify, you did a side-by-side upgrade. Meaning that you installed a new instance of SQL Server 2014?

In that case, if you are ready to rid yourself of the SQL Server 2008 R2 instance then you would need to transfer all of your necessary entities from the 2008 R2 instance to the 2014 instance. That'll include everything it would take to make your clients hit the new 2014 instance. Most notably, you'll be backing up and restoring your databases from the source (SQL Server 2008 R2 instance) to the destination (SQL Server 2014 instance). But you will most likely need to transfer other server objects as well.

Note: Max brought up a good point in his comment below, ensure that you have a valid database backup/restore on your destination instance before removing anything.

how can I abandon the 2008 version and only run on the 2014 version

Point your applications/clients to the new SQL Server 2014 instance after the migration. And then you can rid yourself of the SQL Server 2008 R2 instance if you no longer want those bits to be living on that machine. Warning, you should verify with the business and end users that functionality is now back to the same state as it was prior to the upgrade.

I've check the properties on the SQL 2014, and it shows that I'm still with 2008 R2 Express edition

I'm not sure what you mean here. How did you check the "properties" and what exactly are you referring to? You're either connecting to your old SQL Server 2008 R2 instance, or you new SQL Server 2014 instance. If the former, you'd be in the context of the old one. If the latter, you should be seeing the new 2014 instance. If that's not what you mean, then please clarify.

share|improve this answer
1  
And make sure you have a full and completely tested backup before deleting anything! –  Max Vernon May 22 at 4:18
1  
Agreed and noted. Thanks! –  Thomas Stringer May 22 at 12:07

select @@version will give you which version you are actually connecting to.Also check whether your instance names of both in configuration manager to avoid accidentally connecting

share|improve this answer

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.