I have multiple databases because the size of some log files increases more than normal, although very little data is added to a few tables of about 50 to 100 lines per month.
For example, during the review, I found that the database has a database size of 79 MB and a log file size of 833 MB, and that the log file size increased by almost 100 MB over a week, whereas only about 100 to 150 records were added to one of the records using the contact form with web form, which have only 5-6 fields.
Similar problem occurs in database 1. In this case, the database size is 16 MB, and the log file is now about 554 MB in size.
database 1 is a test database and in the last 1 years no data has been added to this table.
We tried to downsize the database, which did not make a big difference …
I am not sure what to do next and why the database log file is so big. Even if we make a backup
.bak File These files are also great as log files example
Database 10 The .bak file is also about 800 MB in size.
The production server is SQL Server 2014 Standard Edition
Recovery model for database 10 is
Simple and for all other databases
This could be the reason for large log files