Share via


How to clear event cache table in supportable ways

Technorati Tags: event cache,alerts

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

  • Anonymous
    January 01, 2003
    Yes its for event Cache table..

  • Anonymous
    June 14, 2011
    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?

  • Anonymous
    December 27, 2011
    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?

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