1

I know, this kind of question has already been answered some times but I don't find some current answers and wonder if SQL Server Standard Edition 2016 SP1 has changed something in the matter as it supports all "programmability features" earlier supported by enterprise edition only.

My specific scenario is as follows: I have got a central backup server which will be running SQL Server 2017 Standard Edition and regulary restores new backups taken from other SQL Server instances. Most instances will be on SQL Server 2017 Standard as well...however there is a Data Warehouse running SQL Server 2014 Enterprise Edition.

  • Is it possible to restore backups taken from a SQL Server 2014 Enterprise Edition instance on a SQL Server 2017 Standard Edition instance or could this result in an error regarding to Enterprise Edition features?
  • Is there any way to try this out for free? SQL Server evaluation edition is equivalent to Enterprise Edition isn't it or has Microsoft now introduced a way to downgrade developer and evaluation licenses to SQL Server Standard Edition features?

Thank you very much in advance for your assistance

4

I believe it is possible to restore with same old answer that subject to condition you are not using any "enterprise specific" features. This you can get from

select * from sys.dm_db_persisted_sku_features.

If you are using any such feature you would have to stop using it, take fresh backup and then restore. I know its hard to tell because starting from SQL Server 2016 Sp1 standard provides far more features support. So at the last the answer would be you need to restore and test.

Good news is SQL Server 2017 RTM Evaluation Edition is released so you have the Eval edition for your testing.

  • Hi Shanky, thanks for your answer. You mention Evaluation Edition. Doesn't this run Enterprise Edition under the covers and thus wouldn't complain restoring a backup with Enterprise Edition features? – Martin Guth Oct 4 '17 at 10:38
  • 1
    @MartinGuth yep, exactly, Evaluation = Enterprise Edition, just time-limited. – Brent Ozar Oct 4 '17 at 10:49
  • @MartinGuth Yes that is correct my bad i missed this. You would have to purchase standard edition to test it – Shanky Oct 4 '17 at 11:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.