We are running a server with SQL server express which has the recovery model set to simple and the log file (.ldf file) for one of the database has been growing in file size significantly and appears to be growing a fair amount each day & eating into free disk space. Currently the log file is 17.6gb and the database file is 2.10GB.
Initial size (mb) of the database is 2161 and the log file is 18117
Autogrowth / Maxsize of the database is By 1mb, unlimited and the log file is by 100mb, limited to 2097152. Note we did have the log file set to autogrowth by 10% a few days ago but changed to 100mb hoping this would hel, however the log file still seems to be growing too much.
Under the general properties of the Database it says the last database log backup - None, the last database backup is today so not sure if this has something to do with the situation, since we are using the simple recovery model maybe that why it says the logs have never been backed up?
Any recommendations on something we can do to reduce the log file size?, ideally we dont want to impact performance of the database if this can be avoided?