How to clear event cache table in supportable ways

How to clear event cache table in supportable ways

  • Comments 4
  • Likes
Technorati Tags: ,

Method 1:

=========

-To do this, we can an go to central administration > Application Management > Web application general settings > change log > set it to “1”. By default it will be “15” days. This change log setting is directly attached to the “event cache” table of the content database. As you make it to “1”, it will clear up the event cache table on the next day.

Method 2:

=======

1. Take the complete backup of the database for the affected site.
2. Login to CA site->application management->content Database
3. Select the web application having issue.
4. Copy the content database for the reference.
5. Click on the content database and check the option “remove content Database” and click Ok
6. Through command line run the command
7. stsadm.exe -o addcontentdb -url <url> -databasename <database name> -clearchangelog
This should help us to clear the event cache table

Note:

====

switch “clearchangelog” is available only if you have sp2

if you are prior to SP2 use the command without the switch

Comments
  • If you set the change log to 1, does it clear the cache table after 24 hours? Is there a timer job where you can set a specific time for the EventCache to be cleared?

  • Hello!

    I have a problem with cleaning event cashe and event log tables in content database by timerjob "Change Log".

    Method 2 work in SharePoint 2010?

  • hi , is this related to auditdata table or only event cache table. Please let meknow. TIA

  • Yes its for event Cache table..

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment