0

“Database cannot be started in this edition of SQL Server” error when restoring or Upgrading a Microsoft Dynamics CRM 2013 database

I followed my own article here for upgrading from SQL Evaluation to SQL Standard.  I had my Dynamics 2013 environment already stood up and unexpectedly already used for development work.

After the ‘upgrade’ steps, the database appeared to be in (suspect) mode and I didn’t have a backup (but a checkpoint via hyperv at least).

Anyway, I uninstalled the SQL Standard from programs and features.  Reinstalled the Evaluation version (which is Enterprise by the way) and ran this script on Microsoft’s support site against the CRM databases.

I then followed my article and the databases successfully stayed in normal operating non-suspect mode.

Continue Reading