question

neilnborg avatar image
neilnborg asked

Downgrade from SQL 2012 to SQL 2008 R2 Enterprise

We were supplied with an SQL Server STD 2012 license and the supplier told us that to downgrade to SQL 2008 R2 Enterprise we have to buy this license first and then downgrade. Does anyone know how we can do this? I never installed SQL before.
sql-server-2008-r2sql-server-2012licensingdowngrade
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image
Kev Riley answered
It's true that to install 2008R2 now, you have to buy a current licence (i.e. SQL2012) and use the Cross Edition Rights to downgrade, however a SQL2012 Standard licence will only allow you to use SQL2008R2 Standard and below, not Enterprise edition. For more details check out the SQL Server 2012 Licensing Quick Reference Guide (Google that and it will come near the top - it's a PDF) For complete certainty, speak to your licensing reseller.
4 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Those links are talking about Windows Server, not SQL Server. The Quick Ref Guide is clear about what downgraded software can be deployed for each licence type. I'll find a link to post here
1 Like 1 ·
oh right, i didn't even notice that!!
0 Likes 0 ·
Tim avatar image
Tim answered
I agree with Kev Riley, all my talks with MS Licensing and working with virtual servers, EAP's, EA's, etc have stated that SQL 2012 license allows you to run 1 version downgrade. Purchase version 11 and you can run 10.5 of the same edition.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Also be very careful, if this is on a VM that you follow the VM guide lines as well. If licensing at the OSE level then minimum 4 cores and SA.
2 Likes 2 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.