Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

telerik -- supercharge your DNN websites
  Ads  
 


  Sponsors  

Meet Our Sponsors

Verndale
The Official Microsoft ASP.NET Website
Portal Webhosting - Hosting For Developers
Red-Gate Software
MaximumASP
SourceGear - Tools for Developers
 


DotNetNuke Forums
 
  Forum  General DotNetN...  Configure It! (...  Re: Database Backup Size HUGE (history not purging)
Previous Previous
 
Next Next
New Post 8/20/2008 7:27 AM
Unresolved
User is offline Skeets
24 posts
10th Ranked


Re: Database Backup Size HUGE (history not purging) 

Hey Guys,

I've figured out that the history isn't purging on my site.  The schedules are generatign errors.  I took a look at www.mitchelsellers.com/blogs/articletype/articleview/articleid/121/determing-sql-server-table-size.aspx and followed the steps and came up with this: www.mrjanitorialsupplies.com/data_export.htm

Could someone help me figure out how to remove the history and event log so the database size isn't so huge?  It's currently at 0.17 GB, and this increased from 25 mb.

Thanks In Advance,

 

Chris


 
 
New Post 8/20/2008 9:41 AM
User is offline Skeets
24 posts
10th Ranked


Re: Database Backup Size HUGE (history not purging) 

Well, I temporarily solved the issue by manually deleting the table data using the command:  DELETE FROM EventLog; at least the event viewer module works again, my database went from 25 to 0.17 gb in the course of 2 weeks, incredible.  I hope it doesn't happen again.

 

Is there anything I can do to prevent this?  I disabled the scheduling and event recording.  Hopefully that solves the problem.
 
New Post 8/21/2008 8:36 AM
User is offline ETM Penning
35 posts
10th Ranked




Re: Database Backup Size HUGE (history not purging) 

I run this SQL query regularly to keep my db under control:

truncate table EventLog
go
truncate table ScheduleHistory
go
truncate table SiteLog
go

This query clears the tables and since it doesn't record the transaction in SQL Server - it is an instant operation.  You must have db_owner privleges to use this though.
 
New Post 8/21/2008 11:59 AM
User is offline Skeets
24 posts
10th Ranked


Re: Database Backup Size HUGE (history not purging) 

Thanks for the response ETM Penning,

Looks like a good query to hold on to.  Much appreciated.  Will try this out next time if needed

 
 Page 1 of 1
Previous Previous
 
Next Next
  Forum  General DotNetN...  Configure It! (...  Re: Database Backup Size HUGE (history not purging)
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, 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 DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.
 


DotNetNuke Training by Engage Software
Specializing in customized training, architecture and module solutions for large scale implementations lead by DNN Core Team Member Christopher Hammond.
engagesoftware.com 		Smart-Thinker
DNN Modules for Social Networks for as low as $69 for 6 modules! We also maintain the DotNetNuke Directory - http://DNNDir.com
www.smart-thinker.com 		DNN Photo Gallery
Complete Photo Gallery Management!
www.dnnPhotoGallery.com

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP