SQL 2008 Database Restore (Enterprise to Standard) - Issue

Question

Hi,

   I am using CRM 2011 application and sql 2008 R2 Enterprise.

Now, i need to migrate crm to different server which is having sql 2008 R2 Standard.when i am migrating database i from sql enterprise to sql standard i am getting the following error.Kindly guide me to resolve this issue:

---

Cheers : Jeriesh

Answer 1

Hello,

Please see the following article:

"Database cannot be started in this edition of SQL Server" error when restoring a Microsoft Dynamics CRM database
http://support.microsoft.com/kb/2567984  

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 2

Hi Jeriesh

your db is partitioned (or at least has a part function), something not supported on Standard Edition, it must stay on Enterprise. Otherwise get rid of partitioning and try again.

Regards,

         Marco

Answer 3

Hi,

    I go through the link and execute the script and the output is showing command executed successfully.Then once again i took the DB backup from sql enterprise server and try to restore to the sql Standard there it is showing the same error.can you pls guide me...is there is any other solution....

---

Cheers : Jeriesh

Answer 4

Go to the db within MS, open the Storage node and check Partition Functions and Schema, if you still have check which tables or indexes are partitioned, remove them from partition by rebulding cluster index and non cluster indexes onto the file group that suits you, remove the partition schemas and functions, get a fresh back up and do it again.

Regards,

       Marco 

 

To Check which objs are partitioned.

select distinct object_name(a.object_id) tabname 
  from (sys.indexes a inner join sys.tables c
  on a.object_id = c.object_id)
  inner join sys.data_spaces b on a.data_space_id = b.data_space_id
  where b.type='PS'