skip to Main Content

Downgrading from SQL Server Enterprise to SQL Server Standard

Recently I was presented with a situation where one of our CRM clients that we had help upgrade from CRM 2011 to CRM 2016 came to the realization that their 90 day trial of SQL Enterprise that they had used was coming to the end and it was time to buy a license.

Uh Oh! Have you ever looked at the price of Enterprise vs Standard? It is a huge difference. You better be a Fortune 500 company before you make the call to use Enterprise.

So what to do? Backup the CRM database, uninstall Enterprise, install Standard then restore the CRM backup. Hold on, not so quick as that is a long way from working. Read on if you want to know how to get it done.

First off you need to run some scripts to remove the partitioning created to support the AuditBase table. Partitioning is an Enterprise feature it isn’t supported in Standard. If you search for these scripts online you will find several blog postings with the scripts. DON’T USE THEM! The only place you should reference for these scripts are the ones provided by Microsoft in KB2567984 (thank you Gage Pennisi!)

Read through the KB article and then follow these steps:

  1. Backup myorg_mscrm
  2. Rename to myorg_mscrm to myorgSTD_mscrm
  3. Restore to SQL Server
  4. Run the scripts from the KB against myorgSTD_mscrm. That way if something goes wrong your production system won’t be impacted.
  5. Backup myorgSTD_mscrm
  6. If you have an reports developed outside of CRM and published to Reporting Services backup those RDL files now.
  7. Uninstall SQL Enterprise, including Reporting Services
  8. Install SQL Standard with Reporting Services
  9. Configure Reporting Services
  10. Restore the RDL files from Step 6
  11. Uninstall CRM Reporting Extensions
  12. Reinstall CRM Reporting Extensions
  13. Restore myorgSTD_mscrm as myorg_mscrm
  14. Import Org via the Deployment Manager
  15. Run through ADFS and IFD Setup Wizard in the Deployment Manager
  16. Test your CRM system using the new database version.

Put on your happy face 🙂

Leave a Reply

Your email address will not be published. Required fields are marked *

Back To Top