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

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...What I Learned About Database Work inside DNNWhat I Learned About Database Work inside DNN
Previous
 
Next
New Post
9/11/2007 9:26 PM
 

Chad, I've never heard it called eventlog, but it has to be the same considering the amount you reduced the size of the DB. I've never needed these comands becuase I always insist on having Management Access to the DB. If you don't do a lot of transactions and you make regular backups and losing a couple of days work or how ever often you do backups, then if you set the Recovery Model to Simple the DB won't get so big so you won't ever have to do this. Of course there are risks to setting it to simple, mainly that you won't be able to replay transactions since the last backup. I always set mine to simple since I backup every night and if I lose one day then its not that big of a deal. In a situation where you where taking credit card payments and a lot of changes where made every day, I would not suggest this, but for most sites its fine.

hth

Bruce

 
New Post
9/11/2007 9:35 PM
 

Roger that, Bruce...

Newer users such as myself probably get the terms mixed up.  Here I'm thinking it's probably because the SQL command is "TRUNCATE TABLE eventlog"

So, Terp, you have your answer via Bruce.  The TRUNCATE TABLE eventlog is the thing that trims the Transaction log. 

EDIT:

So, never mind, they are not the same, see John's post below.


Chad Voller -- MCP, DNN Aficionado
Leapwise Media
View my View Chad Voller's profile on LinkedIn
 
New Post
9/11/2007 9:40 PM
 

Usually the term Transaction Log refers to the SQL Server Transaction Log. There is one for every DB in a SQL Server Instance.

The EventLog Table stores events that happen inside DNN, the Transaction Log records every transaction that goes through your Database. 

The transaction log can get very large because it is recording all the inserts to the EventLog table and the SiteLog table, and as Bruce pointed out the Transaction Log can be kept to a minimum if the recovery plan is set to simple which is a setting in MS SQL Server management.


DotNetNuke Modules from Snapsis.com
 
New Post
9/11/2007 10:08 PM
 

Terp wrote

..just read this.  How about moving the date forward about 3 weeks to accommodate Terp? I'll be in Germany throughout the month of October, so will be a little late. This is exactly what I need. :)

I can taste the Rahm Schnitzel mit Pommes, Spätzle, und Hefe Weizen now....

Terp, I am sorry, but with respect to our Dutch friends, who host the conference and all ~500 participants it will be difficult to reswchdule the event. However, have a nice time in Germany and  if you come to Karlsruhe, I will be glad to meet you.


Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
9/11/2007 10:12 PM
 

John is correct: SiteLog, EventLog and SchedulerHistory are DNN tables, while the TransactionLog is an SQL server database. DNN tables can be shriked frequently by DNN scheduler, TransactionLog by database maintanance. SiteLog can also be omitted, when saving log to files as I pointed out before.


Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...What I Learned About Database Work inside DNNWhat I Learned About Database Work inside DNN


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