14,501 questions
It is possible, as long as you haven't used any Enterprise feature in the databases. You can check it with
select *
from sys.dm_db_persisted_sku_features
restore database from Enterprise Edition to Standard Edition.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 60%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGS%3C/text%3E%3C/svg%3E)
GAURAV SRIVASTAVA
60
Reputation points
We have databases created on SQL server version: Microsoft SQL Server 2014 - 12.0.2000.8 (X64) Enterprise Evaluation Edition (64-bit).
Is it possible to restore the databases on SQL server version Microsoft SQL Server 2014 - 12.0.2000.8 (X64) Standard Edition (64-bit) which have been backed up from SQL server version Microsoft SQL Server 2014 - 12.0.2000.8 (X64) Enterprise Evaluation Edition (64-bit) ?
SQL Server | Other
{count} votes
-
Erland Sommarskog 121.9K Reputation points MVP Volunteer Moderator2024-01-10T22:52:53.3366667+00:00 Is it possible to restore the databases on SQL server version Microsoft SQL Server 2014 - 12.0.2000.8 (X64) Standard Edition (64-bit
I really hope that you don't have any machines with this particular version. If you have SQL 2014, you should install Service Pack 3 and then Cumulative Update 4, to get as recent as you can get with SQL 2014.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous2024-01-12T08:02:10.9966667+00:00 Hi @GAURAV SRIVASTAVA Did the answer help you? If the answer is useful, please click
Accept Answerto let others with similar questions quickly find answers. If you have any questions, please feel free to let us know. Best regards, Aniya
Sign in to comment
Accepted answer
-
Olaf Helper 47,516 Reputation points2024-01-10T19:51:03.1833333+00:00