Did an in-place upgrade to SQL Server 2014 from SQL Server 2008R2 SP3. Upgrade was successful, no issues detected. However, it did not replace Server 2008R2, both SQL Server Versions are there.

Would it be OK to uninstall SQL Server 2008R2? Or, What would happen if both runs in same server?

Any input would be appreciated. Thanks in advance!

Did an in-place upgrade to SQL Server 2014 from SQL Server 2008R2 SP3. Upgrade was successful, no issues detected. However, it did not replace Server 2008R2, both SQL Server Versions are there.

Would it be OK to uninstall SQL Server 2008R2? Or, What would happen if both runs in same server?

Any input would be appreciated. Thanks in advance!

do you mean to say - you now have two instances of sql one sql 2014 and other sql 2008R2.

If so, you will need to move all the databases\logins\jobs etc..

your servername\instancename would be different too, so, you  need to change the connection string in your applications...

I wonder how that happened, are you sure you did not do new installation 

No, it was an in-place upgrade. There was already a SQL Server 2008R2 running, I didn't uninstall 2008 and install 2014. I mean it was not a migration; just an in-place upgrade. So, I ran SQL 2014 iso and picked upgrade from 2008 to 2014, that's about it.

I was under the impression that SQL 2014 would replace SQL 2008R2 and any possible instance\database\logins\jobs would also be moved over (or stayed where they are since I'm doing everything in the same server)

No, it was an in-place upgrade. There was already a SQL Server 2008R2 running, I didn't uninstall 2008 and install 2014. I mean it was not a migration; just an in-place upgrade. So, I ran SQL 2014 iso and picked upgrade from 2008 to 2014, that's about it.

I was under the impression that SQL 2014 would replace SQL 2008R2 and any possible instance\database\logins\jobs would also be moved over (or stayed where they are since I'm doing everything in the same server)

then you i think you should only have sql 2014 on your box.  in the configuration do you see sql 2008R2 service as well?

Yes, I still see 2008 is installed on Programs in Features. I rebooted the server but still exists. Now, would it be OK to uninstall 2008 though? Would it purge the DB too? I would keep both versions if it doesn't harm...

I can also connect to the DB using SQL Management Studio 2014, everything seems in place including logins, etc. however, when I start Management Studio 2008R2, I don't see the DB name in Server Name field.

Hello,

When you perform an in-place upgrade, after the upgrade finished you still see some components of the old version on the Start menu and on the Control Panel -> Programs and Features. That is by design.

However that does not mean you have two instances. You only have the one SQL Server instance upgraded to the version of the media you used.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

• Proposed as answer by Shanky_621MVP 1 hour 59 minutes ago

Thanks Alberto. Now, is it safe to uninstall the old instances from Programs and Features? I seems like all 2008 programs are still in there. Just don't want to harm DB. I'll leave it alone if it does...

Hello,

Yes, it is safe to uninstall all old components. The upgraded instance does not require any of the old components to work as expected.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Hello,

When you perform an in-place upgrade, after the upgrade finished you still see some components of the old version on the Start menu and on the Control Panel -> Programs and Features. That is by design.

However that does not mean you have two instances. You only have the one SQL Server instance upgraded to the version of the media you used.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

• Proposed as answer by Shanky_621MVP Saturday, July 25, 2015 5:08 AM