question

RajeevSharma-8512 avatar image
0 Votes"
RajeevSharma-8512 asked Cathyji-msft commented

Downgrade from MS sql 2012 Ent to Std

I have a SQL server 2012 Enterprise (licensed) in production which is way under utilized. I need to downgrade it to SQL server 2012 Standard (I have the new Keys if needed)

Can anyone help with this downgrade and best practices etc

TIA

---Rajeev

sql-server-generalsql-server-migration
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi anonymous userSharma-8512,

We have not received a response from you. Did the reply(s) could help you? If the response helped, do "Accept Answer". If it is not, please let us know. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·
JingyangLi avatar image
0 Votes"
JingyangLi answered

You are approaching the end of SQL Server 2012 Extended Support from Microsoft (less than two months).
Can you look at the solution to migrate to SQL Server 2019 Standard version altogether?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

TomPhillips-1744 avatar image
0 Votes"
TomPhillips-1744 answered
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

You need to uninstall and reinstall. Beware that even if the server is under-utilitised, you may still be using features that are only available in Enterprise.

And I definitely echo what Jingyang says. There is all reason to consider an upgrade. If nothing else, lots of stuff that used to be Enteprise-only are now available in Standard Edition. Particularly, this applies to features that relates to the programming surface area.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Cathyji-msft avatar image
1 Vote"
Cathyji-msft answered Cathyji-msft edited

Hi anonymous userSharma-8512,

There is no MS document about how to downgrade of SQL Server edition. And there is no direct method to do that, you have to uninstall SQL server enterprise and install SQL server standard. You need to backup user and system databases, install a SQL Server standard instance then restore databases to it.

In addition, before you downgrade, runs this query in all your databases:

 SELECT *FROM sys.dm_db_persisted_sku_features

If above query returns no results that means you are not using any feature which is edition specific. If it returns any rows, this means that this database has some enterprise only features.

In addition, as others mentioned, Extended support for SQL Server 2012 will end on Jul 12, 2022, suggest you upgrade your SQL server to newer version. Such as SQL server 2019.
203561-screenshot-2022-05-19-104554.jpg


If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.