SQLTeam.com | Weblogs | Forums

Downgrade Sql Server 20014

sql2014

#1

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


#2

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