Forum Discussion
SQL Server ldf file size keeps increasing, but there are no changes in the mdf file
I encountered strange things, the .ldf file size is increasing 50G in one hour, and in two hours, it increased by 100 G. But the .mdf has no big changes, such as lot of entry writes. Do you experts...
Please make sure that database maintenance (jobs, maintenance plans or scripts) are not creating those increase in the size on the database log. Maybe on those scripts you are updating statistics with FULL SCAN or rebuilding indexes, all these are logged operations.
Making frequent log backups of the database can prevent the log from increasing its size or switch the database to SIMPLE recovery model.
Making frequent log backups of the database can prevent the log from increasing its size or switch the database to SIMPLE recovery model.
