locked
MOSS 2007: Does Exporting /Copying Data from AuditData Table in Sharepoint Content database to another Database (warehouse) void support? RRS feed

  • Question

  • Hi there,

    Recently I've found that the AuditData table in one of our Content Databases has blown out in size a fair bit so I'm going to audit trim. However prior to deleting a large portion of the audit data, I want to copy the data to another SQL database I use for warehousing.

    My question is, if I did this, does this void my support with Microsoft? I understand that manipulating SharePoint data directly from SQL voids support but does copying data constitute as manipulating?

    Note: For Audit Trimming I will bein using Stsadm trimauditlog command.

    Hopefuly this is a straight forward question and answer.

    Thanks and regards


    • Edited by Noel Taboada Wednesday, October 10, 2012 5:12 AM
    Wednesday, October 10, 2012 5:10 AM

Answers

  • Noel,

    Direct interaction with the SharePoint databases is forbidden under the terms of use agreed when installing the product and will leave your deployment in an unsupported state.  If the databases are a problem, you may want to consider a SQL maintenance plan rather than tampering with the databases directly.

    Marcel,

    I've unproposed this as the OP's question hasn't been answered and it's generally better form to wait for the community or the poster himself to markl a response.


    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/

    • Marked as answer by Noel Taboada Monday, October 22, 2012 4:50 AM
    Thursday, October 18, 2012 10:05 AM
    Answerer

All replies

  • I can not answer your question, but if you have a supportcontract that you don't want to void. Why don't you contact your local microsoft support office for this info? You already got the supportcontract ;-)

    My SharePoint Blog: www.spstech.net | Twitter: http://www.twitter.com/marceldenouden

    Thursday, October 18, 2012 9:46 AM
  • Noel,

    Direct interaction with the SharePoint databases is forbidden under the terms of use agreed when installing the product and will leave your deployment in an unsupported state.  If the databases are a problem, you may want to consider a SQL maintenance plan rather than tampering with the databases directly.

    Marcel,

    I've unproposed this as the OP's question hasn't been answered and it's generally better form to wait for the community or the poster himself to markl a response.


    Steven Andrews | SharePoint Professional | http://www.twitter.com/backpackerd00d | https://baron72.wordpress.com/

    • Marked as answer by Noel Taboada Monday, October 22, 2012 4:50 AM
    Thursday, October 18, 2012 10:05 AM
    Answerer
  • @Noel thanks will keep that in mind.

    My SharePoint Blog: www.spstech.net | Twitter: http://www.twitter.com/marceldenouden

    Thursday, October 18, 2012 11:49 AM
  • Thanks guys.

    Steven is spot on. No Copying of the AuditData directly from the table.

    Monday, October 22, 2012 4:50 AM