It is not supported to downgrade SQL Server, it is also not supported to upgrade SQL Server 2014 Enterprise to SQL Server 2016 Standard. Table and index partitioning on Standard edition. NOTE: currently, we have 12 cores on Each Machine (very Expensive)Ī little good news, SQL Server 2016 which has applied SP1 can support Please advise if it's possible or Not and if so, what other concerns i need to take in advance(in other words, why not to do it.) In General, i think that it's very risky to downgrade from SQL server 2014 Enterprise Edition to SQL server 2016 Standard Edition.(does it Upgrade Or downgrade?) Please, tell me some other things I did not think about. partitioning - a feature the supported only by Enterprise Edition AlwaysOn Availability(current, i have 3 Nodes in the HA), the Secondary Node canĤ. Online Rebuild Index - a feature the supported only by Enterprise Editionģ. as a DBA, I have several reservations and concerns:In this version I enjoy with some features that not supported on Standard Edition, for Example:Ģ. Server 2016 Standard Edition in order to reduce costs. My company decided to downgrade the SQL server instances from SQL server 2014 enterprise Edition to SQL
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |