I have noticed my 5nine Cloud Security SQL transaction log is large. How can I keep it a manageable size?
It is suggested you review the SQL Recovery model in use. 5nine Cloud Security does not use any capabilities of the Full Recovery model. Switching to a Simple Recovery model will reduce the transaction log size, and in turn, will offer further SQL performance improvements.
Before making any changes, it is recommended you make a backup of your database and understand the differences between recovery models. For an overview of SQL Recovery models please see this Microsoft article.