Restoring data from a (native database) daily-backup

I am trying to test that my native database backup tool is working. I followed these steps:

  1. made a backup of my jiradb using SQL Server, (using SQLServer Mgt Studio)
  2. transferred it to my test server,
  3. restored the jiradb from the backup, (using SSMS)
  4. confirmed from SSMS that the jiradb on the test server looks ok.
  5. I then used /bin/config.bat to confirm that JIRA on my test server is pointed at jiradb (as instructed here)

But when I launch Jira, it acts like there is no database and displays the "JIRA Setup" window. From there it asks if I have "existing data", and if I click that link it asks for the path to the xml backup file. (I didn't make one).

The Help documentation only explains how to restore from an xml backup (even though another page strongly recommends that native db backup tools are used. But I can't find any documentation for restoring the database on the new server from the DB backup file.

3 answers

Might be worth trying this... If your test server did not have an active database before, let the JIRA setup run through that process, then stop the server and perform the database restore.

Restart JIRA after this and you should see your data. Ensure that any plugins, etc are added to JIRA before the restore, just in case.

Well, I can't test your suggestion now, because I gave up and went with the xml backup (which worked fine, btw). But the next time I want to port my production version over to the test server, I'll give you suggestion a try. Thanks.

Kevin, you'll need to copy your application 'Home' directory as well as the DB content. Among other things (like attachment binaries), the application data directory contains a config file telling JIRA what DB connection details to use.

I'm pretty sure I already had the config file -- which is why step 6 worked. But I hadn't thought about the attachments, etc. Thanks

[I get a 405 Not Allowed when I try to edit my own question. Here's the updated version]

I am trying to test that my native database backup tool is working (as strongly advised at the end of step 2 on this page). I followed these steps:

  1. made a backup of my jiradb using SQL Server, (using SQLServer Mgt Studio)
  2. transferred it to my test server,
  3. stopped jira service on test seraver
  4. restored the jiradb from the backup, (using SSMS)
  5. confirmed from SSMS that the jiradb on the test server looks ok.
  6. I then used /bin/config.bat to confirm that JIRA on my test server is pointed at jiradb (as instructed here), and tested connection
  7. restarted jira service

But when I open Jira in a browser, it acts like there is no database and displays the "JIRA Setup" window. From there it asks if I have "existing data", and if I click that link it asks for the path to the xml backup file. (I didn't make one).

The Help documentation only explains how to restore from an xml backup (even though another page strongly recommends that native db backup tools are used. But I can't find any documentation for restoring the database on the new server from the DB backup file.

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,853 views 12 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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot