Transaction log is full

Topics: ASP.NET 2.0
Mar 11, 2014 at 5:19 PM
I am unable to add posts, move posts, or take any action. I get an error at the top of the screen that says the transaction log is full and to see the sys.databases for more information. There is not a table in the SQL db called sys.databases.

How do I clear the transaction log?
Coordinator
Mar 11, 2014 at 5:39 PM
Mar 14, 2014 at 7:19 PM
While an argument can be made either way, for this type of app I would suggest (after fixing the problem) you not log transactions; just make the recovery model simple. Note: if you are running this for real, at least take nightly backups.
Mar 22, 2014 at 10:18 AM
Edited Mar 22, 2014 at 10:18 AM
You can contact your hosting provider to increase transaction log limit as well. It fixed my problem.