Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

David J Ryan September 22, 2020

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

1 answer

0 votes
Petter Gonçalves
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
September 23, 2020

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.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
8.5.0
TAGS
AUG Leaders

Atlassian Community Events