64334: Acronis Cloud Security: I have noticed my Acronis Cloud Security SQL transaction log is large. How can I keep it a manageable size?

use Google Translate

Last update: Tue, 2020-04-07 04:59

Issue

I have noticed my Acronis Cloud Security SQL transaction log is large. How can I keep it a manageable size?

Resolution

It is suggested you review the SQL Recovery model in use. Acronis 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.