I have a Microsoft SQL Database with an LDF of 500MB. Usually, this is less than 1mb. Recovery Model is set to simple. This is SQL Server 2014 Standard x64. Any idea why the LDF would be 500mb if the recovery model is simple? I have tried shrinking it. it caught my eye because it was 22gb.
This is a database for a Practice Management Software for Ortho. I have approximately 500 deployed and this is the only one that is larger than 1 MB when in simple recovery.
This is because Log file won't shrink automatically once it grows.. you can shrink manually(if you are facing storage issues) or leave it as it is..
I would recommend to leave it as it,since file operations are expensive
As per the chat we had ,we concluded the cause for log growth is a deferred transaction