Restoring data from a (native database) daily-backup

Question

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

* made a backup of my jiradb using SQL Server, (using SQLServer Mgt Studio) 
* transferred it to my test server,
* restored the jiradb from the backup, (using SSMS)
* confirmed from SSMS that the jiradb on the test server looks ok.
* 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.

Kevin Mote · Answer

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

Kevin Mote · Answer

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.

Liam Jones3 · Answer

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.