Return to Question

Commonmark migration

edited Jun 15, 2020 at 9:05

1

This one seems to be a common question in most forums and all over the web, it is asked here in many formats that typically sound like this:

In SQL Server -

What are some reasons the transaction log grows so large?

Why is my log file so big?

What are some ways to prevent this problem from occurring?

What do I do when I get myself on track with the underlying cause and want to put my transaction log file to a healthy size?

edited tags

edited Nov 15, 2018 at 15:02

182.2k
28
407
627

sql-server transaction-log shrink auto-growth recovery-model

Question Protected by Paul White♦

occurred Jul 31, 2014 at 7:53

Removed tag in the title; cleaned up tags

edited Dec 5, 2012 at 10:35

96.2k
30
446
701

Why Does the SQL Server Transaction Log Keep Growing or Run Out of Space?

sql-server sql-server-2005 sql-server-2008-r2 sql-server-2012 sql-server-2000 transaction-log

Tweeted twitter.com/#!/StackDBAs/status/276219927311024128

occurred Dec 5, 2012 at 7:02

one last title edit (from me anyway)

edited Dec 5, 2012 at 4:07

18.3k
6
51
74

Loading

edited title

edited Dec 5, 2012 at 2:53

18.3k
6
51
74

Loading

asked Dec 5, 2012 at 2:11

18.3k
6
51
74

Loading