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

This widget could not be displayed.

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.

This widget could not be displayed.

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

This widget could not be displayed.

[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 Sign up to answer
Community showcase
Posted yesterday in Jira

Atlassian Research Workshop opportunity on Sep. 28th in Austin, TX

We're looking for participants for a workshop at Atlassian! We need Jira admins who have interesting custom workflows, issue views, or boards. Think you have a story to sha...

41 views 2 2
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