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:
http://www.dnnskin.com/KnowledgeBas...index.aspx