MS-SQL Database openfire_Log.LDF

While investigating why our OpenFire server is using more disk space than expected we recognized that the OpenFire MS-SQL database log file is currently just over 20 GBytes, probably not a good size for efficient database operation.

Does anyone have a method to shrink this database log to a reasonable or whaterver is a normal size ?

Thank you.

I bet you are using a full recovery model. Changing to simple should resolve that for you.