Sql Server ldf files growing very fast
database, sql-server, sql-server-2012
Solution
So, Finally I got a chance to solve this problem. Actually, when I do perform transaction log backups, it doesn't free the space from ldf files. So, to solve it, first of all, I take full backup of the database. Then try to shrink the database (not files). When I shrink the database, the space from the ldf files was freed.
This is what, that solved my problem.
Visit This link for more brief details as suggested by Aaron Bertrand
Problem
I am using Sql Server 2012. My LDF files are growing very fastly. For example, If I try to change the data type of a 3-4 columns from varchar(10) to varchar(5), then almost 4-5 GB of disk space is consumed. Even, when i run simple insert queries, a significant amount of disk space is consumed. Please tell me What are the possible reasons for growing ldf files so fastly? How can I solve this issue? Thanks.