Products

Solutions

Resources

Partners

Community

About

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...Database size is hugeDatabase size is huge
Previous
 
Next
New Post
7/9/2006 10:16 AM
 

The easiest way to get rid of the sitelog is to turn it of in the Host settings and then run from the Host Menu -> SQL:

truncate table sitelog

You could also use 'delete' but I guess that will time out.

 
New Post
10/18/2006 11:04 AM
 

So what would be a nice way to reduce the size of EventLog table..? And Safe Way? Maybe:

DELETE FROM EventLog WHERE LogCreateDate<15/10/2006

Is anything likely to go wrong - in anyone's experience? Or maybe there is a better/nicer way..???

 
New Post
10/18/2006 1:36 PM
 
I have needed to do it manually just like you show.  It worked and I am not aware of any issues caused by it.  My only suggestion is to run the query using Query Analyzer not the SQL Manager because the SQL Manager tends to timeout easily.

Best Regards,

Robert J Collins | Co-Founder & President

Netlogic Corporation

 
New Post
11/16/2006 8:44 AM
 

I was going to make a backup before attempting to delete some portals in my db that did not get created properly because of some issue that has yet to be resolved. Well, in WH4L my db backup just hung up. I went and looked at the size at it was over 1GB for only 10 moderately active websites and about 10 child portals for demo sites.

I ran the procedure referenced above and found that my Sitelog and EventLog were nearly 900MB but mostly is shows as Unused space. So what causes this? I have tried to pull up my Sitelog to see what is going on, but it just times out. I want to truncate my sitelog, but for some reason all of a sudden I cannot login to my site. I can get to the Home page but no other pages. What will happen if I truncate the Sitelog without turning off logging? Will it try to log the deletions and compound my problem?

Table                                                   Rows            Tot Space   Used Space                         Unused Space

EventLog 23549 755416       194760 KB 56 KB 560600 KB
SiteLog 266844 117888       102768 KB 3448 KB 11672 KB


Forerunner Communications, LLC
DotNetNuke Integration Specialists

 
New Post
11/16/2006 8:58 AM
 

 

It wont hurt to truncate either log without turning off logging.

The amount of free space is caused by settings on the DB in SQL server.  I am surprised that WH4L lets it get that large with all that empty space.


DotNetNuke Modules from Snapsis.com
 
Previous
 
Next
HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...Database size is hugeDatabase size is huge


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out