Why Does the Transaction Log Keep Growing or Run Out of Space?
299
votes
4
answers
357289
views
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?
Asked by Mike Walsh
(18278 rep)
Dec 5, 2012, 02:11 AM
Last activity: Mar 11, 2024, 12:43 PM
Last activity: Mar 11, 2024, 12:43 PM