Is it possible to configure SQL Server 2014 database log shipping with the primary source running on Enterprise Edition and the secondary destination running on Standard Edition?

Question

Hi,

Was wondering if it is possible to configure SQL Server 2014 database log shipping with the primary database (source db) running on Enterprise Edition and the secondary database (destination db) running on Standard Edition for SQL Server 2014? We currently have an existing project (been running for years) where we have an existing production system running on EE, and a new requirement to configure logshipping, but on Standard Edition.

I have tried to search for this information from the MS Documentations to no avail.

Thank you .

Answer 1

Hi，PPMKAW

Based on the database version features, setting up transactional replication between different 2014 versions of SQL Server, as you mentioned, is feasible. However, feature limitations between different versions may affect log shipping, For example, the Data compression, Table and index partitioning that is only available in the Enterprise Edition.

You can refer to this Link for more information, and see the features of different versions in the Features Supported by the Editions of SQL Server 2014.

Best Regards,

Mikey Qiao

---

If you're satisfied with the answer, don't forget to "Accept it," as this will help others who have similar questions to yours.