Rajeev Pentyala – Technical Blog on Power Platform, Azure and AI

Hi,

I got below error, when I was trying to restore an organization database from SQL server enterprise edition to SQL server developer / Data center editions

Database ‘Org_MSCRM’ cannot be started in this edition of SQL Server because it contains a partition function ‘AuditPFN’. Only Enterprise edition of SQL Server supports partitioning.

Reason :-

• When CRM 2011 is installed using a SQL Server Enterprise edition, a partition is automaticallycreated for the auditing functionality of CRM 2011.
• The AuditBase table then uses partitioning (which is only available for SQL Server Enterprise).

Fix :-

• Either upgrade current SQL version to Enterprise
• OR
• We have to run the script to recreate all the indexes on the Primary partition and then drops the partition
• Refer below MSDN KB article

http://support.microsoft.com/kb/2567984

Below is the useful article on the same

Link

🙂