Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

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

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...173 Mb Database173 Mb Database
Previous
 
Next
New Post
5/30/2007 9:09 AM
 

No that will not let me delete anything either

 

I have just found some references to "TRUNCATE TABLE EventLog command" but cant find the actual script

Ever heard of it

 

Cheers


Class Campers -The Home of the Volkswagen camper & Bus Enthusiast
Worlds Cheapest Homes - Need a Cheap Property, cant afford a home
Beeb iPlayer - Need help with the BBC's new iPlayer software
Internet Insurance Quotes - For the the information you will ever require about Insurance
 
New Post
5/30/2007 9:41 AM
 

try

DELETE FROM {objectQualifier}eventlog

to clear the table.


Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
5/30/2007 10:06 AM
 

Managed it, but its still 122 mb seems rather large.  Is this normal

 

Cheers


Class Campers -The Home of the Volkswagen camper & Bus Enthusiast
Worlds Cheapest Homes - Need a Cheap Property, cant afford a home
Beeb iPlayer - Need help with the BBC's new iPlayer software
Internet Insurance Quotes - For the the information you will ever require about Insurance
 
New Post
5/30/2007 11:21 AM
 

you will need to use a tool like SQL Server Management Studio to crunch your database. please check out this blog post, when accessing an .mdf file with a db tool.


Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
6/1/2007 4:01 PM
 

Depends on your other data in the database too though... just the fact that you only have 70 pages doesn't necessarily mean it has to be small... what sort of data is being stored on those pages?  Do you have any document management modules that store documents (or images) in the database instead of the filesystem? 

Our intranet has over 1000 pages, 800 users, ~80 security roles, etc, and we're barely pushing 80mb in the database... I keep my sitelog and eventlog cleared out (at least once a week) and don't store any "extraneous" data in the database -- we have that all stored on a fileserver that gets backed up nightly in it's own job. 

I agree that they database may have something whacked with it and needs to be ran through some utilities to crunch it, but be sure to do some integrity checks and whatnot before that.  can't remember the exact command... DBCC i think is the base command, but then there are tons of options that can run with it.

Additionally, is that the backup file including the log (ldf) file, or are you looking at just the mdf file?  The log can possibly be large and needs to be truncated, just another thing to look into.  I just had a database with a 25gb log file (oops.... I forgot to set up a maintenance plan on it) and had to truncate that one.  Wasn't DNN related though. :)


-- Jon Seeley
DotNetNuke Modules
Custom DotNetNuke and .NET Development
http://www.seeleyware.com
 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...173 Mb Database173 Mb Database


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