Nov 13 2022 01:38 AM
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 help me find what kind of reason can trigger such scenario?
My database is SQL Server Express edition.
My database under simple recovery mode
I tried to run DBCC opentran, but found no hanging transaction
I tried to run DBCC shrinkfile(db_log, 1), but the log file size didn't shrink
Nov 22 2022 12:06 PM