Login
Register
Home
Q&A
Questions
Tags
Send feedback
Sidebar
What causes the Exception: MS SQL transaction log is full?
0
votes
434
views
asked
Dec 2, 2015
by
gary-t-8719
(
14,860
points)
mssql
transaction
log
exceptions
Please
log in
or
register
to add a comment.
Please
log in
or
register
to answer this question.
1 Answer
0
votes
See KB article on
How to shrink MS SQL Server transaction logs for the QIE database?
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.
Please
log in
or
register
to add a comment.
...