Ugrade database only?

Hello,

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 5.2.4.1.

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?

Thanks!

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: https://confluence.atlassian.com/display/JIRA/Upgrading+JIRA+with+a+Fallback+Method

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): https://confluence.atlassian.com/display/DOC/Production+Backup+Strategy

All the best,
John

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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Sunday in Agility

You asked for it, so we delivered: images on issues have arrived

A picture tells a thousand words. And agility boards have just released their latest feature: cover images on issues – so now your board can tell a story at first glance. Upload attachmen...

218 views 2 11
Read article

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