DNN Forums

Ask questions about your website to get help learning DNN and help resolve issues.
  • Search Forums
    Advanced Search
Prev
Next
Forums Using DNN Platform Administration and Configuration

Transaction log bloats and fills up causing issues

 3 Replies
 1 Subscribed to this topic
 40 Subscribed to this forum
Sort:
Author
Messages
Malcolm Bradley
New Around Here
Posts: 10
New Around Here
New Poster
New Poster
Congrats on posting!
2/13/2026 3:08 AM

I really hope there's someone who can help me.  I have a DNN 9.10 installation which every few months causes either the site to crash or if noticed early enough will not allow users to login.

When attempting to login the following message appears...

The transaction log for database 'xxxxxxx.com' is full due to 'LOG_BACKUP'.

My host support team reports the database has bloated significantly so they reduce the size of the database and all is well again.

I had sugested this https://www.dnnsoftware.c...d/334554/scope/posts

The issue still persists.

I have turned off all event logging so there are no Events logged at all but still the database bloats and causes either no one is allowed to login or the site to crash...

Any help will be gratefully received.

Many thanks,
Malcolm

Mitchel Sellers
Advanced Member
Posts: 132
Advanced Member
Helpful Replier
Helpful Replier
Thanks for being such a helpful replier!
MVP
MVP
You're an MVP!
2 Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
2/13/2026 4:18 AM
If you are on a hosting provider with a small DB size requirement, or one that doesn't do traditional database backups that auto-truncate the logs you can get this issue due to natural churn on some of the tables in the DB.

You may reach out to them and ask if you can change to "Simple Loging" rather than full which will help the file not bloat. Or have them do regular backups with the truncation of logs.

NOTE: If you change to simple logging it DOES impact the recovery model though so it should be discussed with your hosting provider to ensure that it doesn't put you at risk.
Malcolm Bradley
New Around Here
Posts: 10
New Around Here
New Poster
New Poster
Congrats on posting!
2/13/2026 8:56 AM
Many thanks Mitchel, I'll ask my support folks to give it a go and see what happens.
Malcolm Bradley
New Around Here
Posts: 10
New Around Here
New Poster
New Poster
Congrats on posting!
2/14/2026 3:01 AM
A quick update Mitchel - this is the response from my hosting support. Hopefully all good news going forward :-)

Setting the 'Recovery Model' to Simple is what we've been previously doing to rectify your DNN databases for other sites historically, but this xxxxx.com database got reverted to 'Full' recovery model.
We've now set this database Recovery Model to Simple again, and this time set a trigger on the database server that should lock that Simple model in place (if any attempt is made to revert that to Full, it should be blocked)
So hopefully that should now resolve this going forward.

These Forums are for the discussion of the open source CMS DNN platform and ecosystem.

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

  1. If you have (suspected) security issues, please DO NOT post them in the forums but instead follow the official DNN security policy. 
  2. No Advertising. This includes the promotion of commercial and non-commercial products or services which are not directly related to DNN.
  3. 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.
  4. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  5. No Flaming or Trolling.
  6. No Profanity, Racism, or Prejudice.
  7. Site Moderators have the final word on approving / removing a thread or post or comment.
  8. English language posting only, please.

Would you like to help us?

Awesome! Simply post in the forums using the link below and we'll get you started.

Get Involved