I have several databases, for some log file size is growing more than normal even though very little data is added to few table around 50-100 rows a month. i.e. Database 12 data file size is 79MB and it log file size is 833MB, and over a week log file size has increased by almost 100MB while only about 100-150 records were added into one of the contact table using web form which only have 5-6 fields.
Similar issue with database 1 , database size is 16MB and log file now is around 554MB,
database 1 is a test database and no data was added to this DB over last 1 year.
We have tried shrinking database that didn't make much difference...
Not sure what should i do next & why database log file is so huge. Also when we take backup
.bak file those files are also large as log files example
Database 10 .bak file is also around 800MB.
Production server is SQL Server 2014 Standard edition
Recovery model for Database 10 is
Simple and for all other databases its
could this be the reason for large log files