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

Issue

I have noticed my 5nine 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. 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.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.