Sidebar

What causes the Exception: MS SQL transaction log is full?

0 votes
533 views
asked Dec 2, 2015 by gary-t-8719 (14,860 points)

1 Answer

0 votes
answered Dec 2, 2015 by gary-t-8719 (14,860 points)
commented Jan 11, 2016 by chris-m-8014 (760 points)
If point-in-time recovery isn't necessary on your SQL database you can set the database to Simple recovery mode.  Doing this should make it so you don't ever have a full transaction log.
...