locked
CRM 2011 Partition not available for auditbase table RRS feed

  • Question

  • I noticed today when going into the audit table there are no partitions any longer. I get the message "No deletable Audit logs available" Any help on how to get CRM to use partitions again would be of great help as the auditbase table is quite large.

    Wednesday, February 27, 2013 9:35 PM

Answers

  • Hi,

    The audit option automatically manage this for you, see the behavior that depends the version of sql server:

    • If you are using SQL Server Enterprise edition partitioning will be in use.
    • If you are using SQL Server Standard edition partitioning will not be in use.

    See more information here.

    Hope this helps.
    If i answered your question, please mark the response as an answer and also vote as helpful.



    Pedro Azevedo Crm Specialist 4.0\2011

    • Proposed as answer by Azevedo PedroMVP Thursday, February 28, 2013 12:24 PM
    • Marked as answer by JenniferNHS Monday, June 16, 2014 1:20 PM
    Thursday, February 28, 2013 12:24 PM

All replies

  • Hi,

    The audit option automatically manage this for you, see the behavior that depends the version of sql server:

    • If you are using SQL Server Enterprise edition partitioning will be in use.
    • If you are using SQL Server Standard edition partitioning will not be in use.

    See more information here.

    Hope this helps.
    If i answered your question, please mark the response as an answer and also vote as helpful.



    Pedro Azevedo Crm Specialist 4.0\2011

    • Proposed as answer by Azevedo PedroMVP Thursday, February 28, 2013 12:24 PM
    • Marked as answer by JenniferNHS Monday, June 16, 2014 1:20 PM
    Thursday, February 28, 2013 12:24 PM
  • Thank you Pedro,

    I have my dba looking into the server to see if something is amiss. I will keep you posted as to what is found.

    Monday, March 4, 2013 3:21 PM
  • Did you find a solution to this? I have the same issue.
    Monday, November 10, 2014 9:25 AM