Ugrade database only?


Due to a recent database failure, we have had to restore our Jira database (SQL Server 2008). The latest backup that we could find seems to have been from build 846, which I believe corresponds to Jira

Our Jira install is at version 6.0.1 (Windows 2008 R2) so our database is a lot older than the install is. We realize that we're not going to get the data back that was lost, but is there a way to run the database schema update scripts to get the database version back in synch with the server version? Or is the best approach to roll back the server till it matches the database, then re-run the updater?


1 answer

1 accepted

Hi Scott,

If you point your Jira 6.x instance at a database that contains JIRA 5.2.x data then the instance will run upgrade tasks on the database and upgrade the data for you to make it compatible with your current version of JIRA. Of course you should do this in a test environment first, but if you follow the instructions in this document this should give you all the pointers you need to do this:

The important thing is that you try it with a copy of your data first, and take regular backups, so I'd like to suggest that once you get this fixed that you consider implementing a proper production backup strategy, as described in this document, (for Confluence but the exact same applies to JIRA):

All the best,

Thanks John, I'll check it out and step through it.

As for the backup strategy, we have good backups of the instance, but need to take a good look at our database strategy. Obviously.

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Julia Dillon
Posted Tuesday in Jira

Tell us how your team runs on Jira!

Hey Atlassian Community! Today we are launching a bunch of customer stories about the amazing work teams, like Dropbox and Twilio, are doing with Jira. You can check out the stories here. The thi...

553 views 1 18
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you