SQLTeam.com | Weblogs | Forums

Downgrade Sql Server 20014

Hi,

What is the best practice to downgrade from SQL SERVER 2014 Enterprise Edition to SQL SERVER 2016 Standard Edition
when always On High Availability is involved with 6 DB's replicated

Thanks,
S

If your databases are not in SQL Server 2016 Compatibility level:

image

And you are not using any enterprise-only features, you should be able to detach the db from 2016 and attach it to 2014