Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
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 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
272 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 May 16, 2023

Thanks @Rilwan Ahmed !

Like
Reply

Suggest an answer

Log in or Sign up to answer
Jira
Jira Software
TAGS
AUG Leaders

Atlassian Community Events

    See all events