Create
cancel
Turn on suggestions
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Product Q&A
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

Does Jira need to be stopped prior to running MS SQL Backup?

Dio Lim
Dio Lim
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Get involved
May 16, 2023

Hi,

 

We run Jira on-premise with a MS SQL Server 2019 back-end.

The Jira team requests us to only run MS SQL Full backup while Jira is stopped.

I can't find anything in the KB around the reason behind this request.

 

Is there a reason why Jira needs to be stopped?

Answer
Watch
Like Be the first to like this
395 views

1 answer

1 accepted

1 vote
Answer accepted
Rilwan Ahmed
Rilwan Ahmed
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Become a leader
May 16, 2023

Hi @Dio Lim ,

Welcome to the community !!

If its a daily backup process ,then not required. Else if you are doing it before any maintenance, then you should stop jira and take the backup. So that present data will not be missed. 

If you do not stop jira before backup, there are chances that the updates to jira during backup process is not captured in the backup file. 

View More Comments
Matthias Gaiser _K15t_
Matthias Gaiser _K15t_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Become a leader
May 16, 2023

In addition to that, doing a full backup while Jira is running might result in a bad Jira performance.

Like • Rilwan Ahmed likes this
Dio Lim
Dio Lim
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Get involved
May 16, 2023

Thanks @Rilwan Ahmed !

Like
Reply

Suggest an answer

Log in or Sign up to answer
Jira
Jira
TAGS
atlassian, team '25, conference, certifications, bootcamps, training experience, anaheim ca,

Want to make the most of Team ‘25?

Spend the day sharpening your skills in Atlassian Cloud Organization Admin or Jira Administration, then take the exam onsite. Already ready? Take one - or more - of 12 different certification exams while you’re in Anaheim at Team' 25.

Learn more
AUG Leaders

Upcoming Jira Events