February 14, 2017 at 7:37 am
Is it legal to restore a SQL 2014 "Enterprise" database BACKUP to a SQL 2016 "Standard" edition instance?
February 14, 2017 at 7:39 am
Express12 - Tuesday, February 14, 2017 7:37 AMIs it legal to restore a SQL 2014 "Enterprise" database BACKUP to a SQL 2016 "Standard" edition instance?
Yes.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
February 14, 2017 at 8:00 am
SELECT feature_name FROM sys.dm_db_persisted_sku_features ;
But I believe the latest release of SQL Server 2016 is now mostly feature complete when compared to enterprise edition. First insure you have installed 2016 SP1.
https://www.mssqltips.com/sqlservertip/4574/new-features-in-sql-server-2016-service-pack-1/
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
February 15, 2017 at 6:33 am
Cool post! I've never tried restoring from Enterprise to Standard. Just confirmed that I was able to restore without any issues (from 2012 Enterprise to 2014 Standard).
SELECT feature_name FROM sys.dm_db_persisted_sku_features returned no results so we don't have any Enterprise only features the database I restored.
February 20, 2017 at 11:59 am
Phil Parkin - Tuesday, February 14, 2017 7:39 AMExpress12 - Tuesday, February 14, 2017 7:37 AMIs it legal to restore a SQL 2014 "Enterprise" database BACKUP to a SQL 2016 "Standard" edition instance?Yes.
Although the backward server needs to have the same Service Pack and (I think) the same CU level.
From a licensing perspective there aren't any problems.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply