Phone: (480) 722-1227
Toll Free: (888) 722-1227
How to Delete DNN Useless Data and Clean the Search Index?
Last Post 07 Jul 2010 07:19 PM by SuperUser Account. 0 Replies.
Printer Friendly
You are not authorized to post a reply.
Author Messages
SuperUser AccountUser is Offline
Basic Member
Basic Member

07 Jul 2010 07:19 PM  
1. DNN daily cleaning:

Go to host>SQL (run as script)


Truncate table {databaseOwner}{objectQualifier}Eventlog

Truncate table {databaseOwner}{objectQualifier}SiteLog

Truncate table {databaseOwner}{objectQualifier}ScheduleHistory

Truncate table {databaseOwner}{objectQualifier}SearchItemWordPosition


2. Reindex DNN site's search:

First clean up the tables: host>SQL>run as script:


Delete {databaseOwner}{objectQualifier}SearchItemWordPosition
Delete {databaseOwner}{objectQualifier}SearchItemWord
Delete {databaseOwner}{objectQualifier}SearchWord
Delete {databaseOwner}{objectQualifier}SearchItem


Then re-index the content:

Host>search admin>re-index the content

Thanks to:
You are not authorized to post a reply.

Active Forums 4.2
Vigilant Technologies
Vigilant Technologies is a certified 8(a), Veteran Owned company headquartered in Chandler, Arizona. We provide products, services and enterprise-wide integration of innovative IT solutions to commercial, Federal, State and Local government clients. Our Leading edge services include Private/Hybrid Cloud, Server Consolidation, Visualization implementation, and Infrastructure Management.
Engage with us
Copyright 2006 - 2013 Vigilant Support   |  Privacy Statement  |  Terms Of Use