Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Dynamics CRM 2013 - SQL support? RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi guys.

    We have installed Dynamics CRM 2013 (currently just for test purpouse) in our environment. So we have put SQL 2012 R2 STD with sp1 on the same server where Dynamics CRM 2013.

    The idea in the future, when we Will move this to our production environment... We have a dedicated sql server and we are planing to move SQL databases to that server, but that server is using 2008 r2 enterprise SP1 SQL. Is it supported to attach/detach SQL 2012 R2 STD db to SQL 2008 r2 SP1?

    bostjanc

    Tuesday, April 29, 2014 7:00 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Your problem is not CRM - but SQL:

    You cannot restore a SQL 2012 Database into SQL 2008 - it's just not possible as there is not "forward compatibility" meaning SQL 2008 cannot recognize an SQL 2012 DB (You can go through a horrible import/export procedures but it just won't work).

    Please vote if you find my post helpful - Thanks

    • Proposed as answer by TZ00KI Monday, May 5, 2014 11:42 AM
    • Marked as answer by B_C_R Monday, May 5, 2014 11:45 AM
    Monday, May 5, 2014 11:41 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    I have not seen anything specific from MSFT on this topic. But judging from this workaround I'd say it is not likely supported.

    FYI, if you create an Organization using Standard edition you would lose the partitioning feature for Auditing, even after you re-import that Org to a deployment that uses Enterprise edition:

    For Microsoft Dynamics CRM servers that use Microsoft SQL Server Enterprise editions, auditing data is recorded over time (quarterly) in partitions. A partition is called an audit log in the Microsoft Dynamics CRM Web application. Partitions are not supported, and therefore, not used, on a Microsoft Dynamics CRM 2011/2013 server that is running Microsoft SQL Server Standard edition.

    Although you can re-enable partitioning in Enterprise edition with a SQL script from MSFT CRM Support but do you really want to make it this complicated?

    Ronald


    • Edited by Ronald Liu Friday, May 2, 2014 6:57 AM
    Friday, May 2, 2014 6:50 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Your problem is not CRM - but SQL:

    You cannot restore a SQL 2012 Database into SQL 2008 - it's just not possible as there is not "forward compatibility" meaning SQL 2008 cannot recognize an SQL 2012 DB (You can go through a horrible import/export procedures but it just won't work).

    Please vote if you find my post helpful - Thanks

    • Proposed as answer by TZ00KI Monday, May 5, 2014 11:42 AM
    • Marked as answer by B_C_R Monday, May 5, 2014 11:45 AM
    Monday, May 5, 2014 11:41 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thanks for the clarifying that.

    Soo we must take a look from other point of view. The 2008 r2 upgrade to sql 2012 r2.

    bostjanc

    Monday, May 5, 2014 11:45 AM