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
Interests
See all
Community resources
Top groups
Explore all groups
Community resources
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Join now to unlock these features and more

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Get started Tell me more
Atlassian Community about banner
4,556,360
Community Members
 
Community Events
184
Community Groups

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
125 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
AUG Leaders

Atlassian Community Events

See all events