You need to Register for free and Login to post a message in the forum.

Forum

Forums > DotNetNuke® > Modules
Subject: Reduce the database size
Prev Next
You are not authorized to post a reply.

Author Messages
AnuPaddu
Nuker
Nuker
Posts:19
29 Jun 2009 8:40 AM  
Hello,

I need to delete Event log details in database. Whether i can go and delete it straightly in the db. If it so it wont affect any other references? coz i need to reduce my database size. Any other ideas plzzz

Thanks,
AnuPaddu

[script removed]
Joseph Craig
DNN Creative Staff
Nuke Master V
Nuke Master V
Posts:5354
29 Jun 2009 1:44 PM  
Use the SQL page under host, enter "Truncate Table EventLog," and then click Execute.

I also refer you to Mitchel Sellers blog (mitchelsellers.com) for discussion of this and also a module that automates some maintenance tasks.
Joe Craig
DNN Creative Support
Subscribe to the website
Lee Sykes
DNN Creative Staff
Nuke Master V
Nuke Master V
Posts:5307
01 Jul 2009 4:08 PM  
you can set your scheduler to automatically delete old event logs. also in the event logs, you can set how many event logs should be kept, some of them are set to * unlimited, and you may want to change this to just 20 log entries.

We cover this in detail here:
Site logs, Event logs and Scheduler
Lee Sykes
Site Administrator
Subscribe to the website : DotNetNuke Video Tutorials : The Skinning Toolkit : DotNetNuke Podcasts

Twitter: www.twitter.com/leesykes

Lee Sykes's Facebook Profile
You are not authorized to post a reply.
Forums > DotNetNuke® > Modules > Reduce the database size


ActiveForums 3.7

Latest Forum Posts

Regarding Editor by prithviraj
Pls let me know whar folders we need to upload when we are changing editors. Suppose i have cute edi...
RE: Change Registration Redirect? by leesykes
It would be best to use Dynamic Registration to avoid 2 registrations.With Dynamic Registration you ...
Indexing DNN pages by Google by Jake Vizner
I have two different DNN web sites. Using Google Webmaster Tools I can see the Google indexed 12 out...
Query Regarding RAD EDitor by prithviraj
Hi, I'm using R.A.D editor in my site. At the time of adding images through the editor I'm unabl...
RE: while installing bulk emailer module in my website by jncraig
Yes, this definitely is a file permissions issue. The default ASP.NET worker task needs to have ful...
RE: Background Music by jncraig
That will work.
RE: Auto create pages and content by dhassall
Hi Joe DNN Out of the box version 4.9 Login as Host with Firefox to create and IE8 to monitor, CTR...
RE: while installing bulk emailer module in my website by dub
Agiline, We have seen this problem before. It is caused by the Security on IIS. Please have a loo...
RE: Change Registration Redirect? by ollep
Probably still want to do it with Dynamic Forms now.My reason for changing (except from getting Aweb...
RE: Change Registration Redirect? by ollep
YES!http://www.dnncreative.com/Subscribe/tabid/81/Default.aspx
RE: Change Registration Redirect? by ollep
Yes I noticed that we where talking about 2 different Modules as soon as I dug into the tutorials.Ab...
RE: Change Registration Redirect? by leesykes
If you are check out the links that I have placed in there:http://www.dnncreative.com/Subscribe/tabi...
RE: Change Registration Redirect? by leesykes
Are you referring to when subscribing there is a link to register and after they register it sends t...
RE: Change Registration Redirect? by leesykes
The method I use on here for managing my email list is complicated and involves SQL queries, it is b...
Ecommerce module needed by vishalranaut
Infyecommerce is providing ecommerce packages for the clients to develop their ecommerce sites.They ...
RE: DS Dynamic Forms / AWeber by leesykes
If you are getting time out issues when installing I would use the auto install method by using FTP,...
RE: Change Registration Redirect? by ollep
Oooops Helps reading your responses before posting here Lee. I referred to Issue 40 / 41 and ...
DS Dynamic Forms / AWeber by ollep
Thanks for a great Tutorial Lee!  - As usual.(I still can't install the module in Firefox though, Fi...
while installing bulk emailer module in my website by agiline
Hi all,i have downloaded bulk e mailer trial version and when i am installing it in my website it wa...
RE: Creating Portals before setting the host by cyborama
Hello Joe, Just got done speaking with my hosting company in reguards to A records and host head...
DNM Rapid Application Developer Trial Version
RSS Feeds