sql-serverdatabasesql-server-2012

Sql Server ldf files growing very fast

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.

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