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

Forum

Reduce the database size
Last Post 2009-07-01 10:08 PM by Lee Sykes. 2 Replies.
Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
AnuPadduUser is Offline
Nuker
Nuker
Posts:19

--
2009-06-29 02:40 PM  
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

<!--Session data-->[script removed]
Joseph CraigUser is Offline
DNN Creative Support
Nuke Master VI
Nuke Master VI
Posts:9001
Avatar

--
2009-06-29 07: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 DNNCreative
I recommend PowerDNN for DotNetNuke Hosting.
Lee SykesUser is Offline
DNN Creative Staff
Nuke Master VI
Nuke Master VI
Posts:4945
Avatar

--
2009-07-01 10: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/DNNCreative

Lee Sykes's Facebook Profile
You are not authorized to post a reply.

Active Forums 4.3

Latest Forum Posts

Admin menu problem by alireza arabiyan
hi i installed dnn 6 on localhost and move it in my host, all link's , pages and modules are ok,
Re: SQL SERVER 2008 R2 Remote connection by Prakasam Srinivasan
I have successfully configured MSSQL Server 2008 r2 remote connection. I am using windows 7 and it h
RE: dnn 4.4 upgrade issue by imran shaikh
Thanks you all it is done by renaming release.config to web.config procedure
RE: dnn 4.4 upgrade issue by imran shaikh
Thanks you all it is done by renaming release.config to web.config
dnn 4.4 upgrade issue by imran shaikh
hi this is imran i am upgrading dnn 4.4 to dnn 6.0.2 and getting this error please help me for this
RE: How to build Skins for DNN 6.x by Joseph Craig
I'd recommend that you try replacing the hard-coded text with the DotNetNuke Text skin object. That
RE: Module permission does not work! by Joseph Craig
What permissions have you give to that role?
RE: DNN nav issue by Joseph Craig
Are you using a custom skin? How often does this happen?
RE: Friendly URLs Broken by Joseph Craig
I don't entirely understand this, but I'm glad you got things working.
RE: How to build Skins for DNN 6.x by Christopher Adamakis
Dear all, I have one more question regarding greek fonts. If you check my site http://www.expertsoft
RE: Dnn local setup problem by imran shaikh
this is error is resolve now now getting this one Server Error in '/cooperpharma.ma' Applicat
RE: Module permission does not work! by Abraham Tameru
I created a special role for the user to administer the site. The user is not a member of the Admini
Dnn local setup problem by imran shaikh
Hi All i have just installed the new site files on my local computer set the connection strin
RE: Firefox has detected that the server is redirecting the request for this address in a way that will never complete. by imran shaikh
Hi i have the same issue Firefox has detected that the server is redirecting the request for thi
DNN nav issue by imran shaikh
Hi All This is imran i am using DNN 6.0 in which issue is that while i am refreshing the site nav
RE: Problem After Attaching/Detaching Database.mdf by Prakasam Srinivasan
thanks joe! But I have connect with database.mdf file in App_Data. I detach the database from
RE: Ventrian News Article by Collin Stefani
Posted By Joseph Craig on 2012-01-18 10:51 AM I'm not sure that you can with the built-in UI.
RE: Friendly URLs Broken by Vistalogix Corporation
Well, we figured out that the problem is related to .Net framework 3.5. Friendly URLs works fine und
RE: Problem After Attaching/Detaching Database.mdf by Joseph Craig
That behavior of running the installation wizard indicates a problem connecting to the database.
RE: Friendly URLs Broken by Vistalogix Corporation
Nope, just a straight-up DNN install and configured in Host -> Friendly URLs as described in my orig
You are not logged in.
You must log in to access all 
650+ videos, tutorials, podcasts, and more.
RSS Feeds