Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Upgrade SQL Server 2008 to 2008 R2 [closed]

I have currently installed SQL Server 2008 (dev edition) in my machine. I wish to upgrade to SQL Server 2008 R2. How is that possible?

Please support the same with screenshot to make understanding better.

Thanks

EDIT: I could have gone for Google Search but the attached screenshot provides no option to upgrade to SQL Server 2008 R2 Edition (Attached Screenshot is of SQL Server 2008 Dev Edition). Please see the text written under "Upgrade from.... 2005"

Please see image desc

like image 487
xorpower Avatar asked Feb 13 '12 10:02

xorpower


People also ask

Is SQL Server 2008 R2 still supported?

Summary. Microsoft SQL Server 2008 and SQL Server 2008 R2 have approached the end of Extended Support. As of the dates in the table below, there will be no additional: Free security updates on-premises.

When did SQL Server 2008 go out of support?

Windows Server 2008/2008 R2 and SQL Server 2008/2008 R2 have both met their end-of-life dates: July 9, 2019 for SQL Server 2008/2008 R2 and January 14, 2020 for Windows Server 2008/2008. If you're still running any of those machines, you're doing so at your own risk—especially in this age of cyberattacks.


1 Answers

The option should appear in the "SQL Server Installation Center" as confirmed by the following screenshot and point 4 of the Microsoft guide on How to Upgrade to SQL Server 2008 R2 (Setup)

enter image description here

As a side note, have you checked your intended upgrade path is supported? You can find out here

like image 166
benni_mac_b Avatar answered Oct 11 '22 21:10

benni_mac_b