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

HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...Advice about managing MSSQL transaction log file sizeAdvice about managing MSSQL transaction log file size
Previous
 
Next
New Post
6/22/2014 10:50 PM
 
Thanks for all the advice, I'll back up and switch to SIMPLE and see what happens!
 
New Post
6/23/2014 11:39 PM
 
400M seems huge for size of transaction log although it's all relative to how active your site is and size of the database. First thing to do is check if you have transactions which all still open. Transactions should be opened and closed within seconds. Opened transactions will let the transaction log backup truncate up to the first opened transaction. There's a system stored procedure which you can run to get info about opened transactions. I can't remember the name of it. Easy to Google it.

Second.. you should have log backups running several times a day. How frequent depends on the activity of your database. Activity includes deletes, updates and inserts. These are logged. You should ask your host or server admin and see if there are any scheduled jobs running to do log backups. If not, ask them to set one up. If you switch to simple mode, you will lose all the transactions since the last full or deferential backup if you ever need to restore your database after a crash.. If that's not important for you, simple is fine. However if you want to be able to restore everything up to the point of database crash, keep the full recovery model and investigate why the transaction log is big. The points I mentioned will help you in that direction. Instead of working around a problem, find the cause of the problem.
 
New Post
6/24/2014 12:29 AM
 
Ok, I've set up a new maintenance task that does a full back up of all user databases once a week and takes a daily differential of all user databases. Trans logs will be backed up every hour. I also set up a clean-up task to clear backups older that 2 weeks. I guess I should see a drop in transaction log size as it will be able to truncate the logs after backup...

Does this sound like a viable plan?
 
New Post
6/24/2014 1:08 AM
 
Also interesting to note I have 2 sites with huge log files, 1.3 gig and 1.5 gig respectively. One of these sites hasn't even been released to the public yet, they both run DNN 7.2, the other sites on this server are on different versions and have much smaller transaction log files. Don't know if that means anything top anyone but thought I'd throw it in.
 
New Post
6/24/2014 3:03 AM
 
large log files usually indicate missing backup with log truncate - or heavy activities even during backups, preventing files from being shrinked. Stopping the Website, switching Backup mode to simple and truncating the log files before switching Back to full backup (if needed) would be the solution to shrink very large log files.

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
Previous
 
Next
HomeHomeOur CommunityOur CommunityGeneral Discuss...General Discuss...Advice about managing MSSQL transaction log file sizeAdvice about managing MSSQL transaction log file size


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