Answered by:
downgrading SQL server

Question
-
Wondering if anyone has ever downgraded sql server 2008 from enterprise to standard with a crm deployment. If so have you experienced any issues with this downgrade?Wednesday, July 30, 2014 8:21 PM
Answers
-
Hi Jennifer,
I never did this downgrade, I suggest to check this link http://social.technet.microsoft.com/Forums/sqlserver/it-IT/113f62cb-f1ef-4e0a-9bf3-b97dccf1a87e/downgrade-sql-server-2008-enterprise-to-sql-server2008-standard-edition?forum=sqldatabaseengineMy blog: www.crmanswers.net - Rockstar 365 Profile
- Marked as answer by JenniferNHS Monday, January 5, 2015 10:30 PM
Wednesday, July 30, 2014 11:06 PM -
There is one specific consideration - CRM applies partitions to the audit tables if partitioning is available (which is with SQL Enterprise Edition, but not SQL Standard Edition). To resolve this I think you need to remove the partitions via SQL before you remove SQL Enterprise
Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk
- Marked as answer by JenniferNHS Monday, January 5, 2015 10:30 PM
Thursday, July 31, 2014 1:36 PMModerator
All replies
-
Hi Jennifer,
I never did this downgrade, I suggest to check this link http://social.technet.microsoft.com/Forums/sqlserver/it-IT/113f62cb-f1ef-4e0a-9bf3-b97dccf1a87e/downgrade-sql-server-2008-enterprise-to-sql-server2008-standard-edition?forum=sqldatabaseengineMy blog: www.crmanswers.net - Rockstar 365 Profile
- Marked as answer by JenniferNHS Monday, January 5, 2015 10:30 PM
Wednesday, July 30, 2014 11:06 PM -
There is one specific consideration - CRM applies partitions to the audit tables if partitioning is available (which is with SQL Enterprise Edition, but not SQL Standard Edition). To resolve this I think you need to remove the partitions via SQL before you remove SQL Enterprise
Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk
- Marked as answer by JenniferNHS Monday, January 5, 2015 10:30 PM
Thursday, July 31, 2014 1:36 PMModerator