Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
CRM 2011 Partition not available for auditbase table RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    Did you find a solution to this? I have the same issue.
    Monday, November 10, 2014 9:25 AM