Our Jira Log has grown really big, does it require full recovery model sql?

David J Ryan

Lately our JIRA Tlogs have grown really big; and I noticed the SQL recovery model is set to full, as I didn't configure this I am wondering if JIRA requires the database to be in full recovery?

What are the recommended database requirements to run this smoothly and keep logs sizes down?

thanks

David

Petter Gonçalves

Hello @David J Ryan

Thank you for reaching out.

Jira application does not require the SQL database to be in full recovery model, however, I'm not sure if this setting is configured by default when configuring the database initially.

Anyway, if you don't need the SQL recovery model to be set as "full" for any specific reason, you can properly change it to "Simple" by following the steps of the documentation below:

View or Change the Recovery Model of a Database (SQL Server) 

The log size will be significantly smaller after the approach above since the "full" mode registers every SQL transaction that happens, not necessarily required in some cases.

Additionally, please be aware of the following actions that must be done after changing the recovery model to "Simple":

• Discontinue any scheduled jobs for backing up the transaction log.

• Also, ensure periodic database backups are scheduled. Backing up your database is essential both to protect your data and to truncate the inactive portion of the transaction log when using the simple Recovery model

Let us know if you have any questions.