Database connection issues

[Iryna Pazharytskaya]

Hello,

Currently we are trying to connect Jira to our sql server data base through the ScriptRunner "Database connecion" option.

Is there anything I am doing wrong or any furher configurations are needed in order to perform the connection? 

Thank you in advance.

Best,

Iryna

[Paula Silveira · Accepted solution]

Hi Zoltan,

Indeed backups aren't automatically generated on Cloud and as Nic mentioned, you need a script to request the backups for you, you can have an example of script on Automatic backups for JIRA Cloud.

Thanks and regards,
Paula Silveira

[Zoltan Bakcsa]

thank you!

[Mauro Badii]

To add more info to the answer: Daily backups are performed for all Cloud instances automatically. These are for emergency recovery purposes and cannot be downloaded.

More information can be found at Data storage FAQ

[Nic Brough -Adaptavist-]

There's no facility for doing this on Cloud.  You'll need to script something external that can log in, click the button and save the results somewhere on your client or server machine.

And it's not daily, you can only use it once every 48 hours.

[Zoltan Bakcsa]

thank you!

[Eyar Zilberman]

I came across the same problem so I decided to create a script to automatically download the backup file and upload it S3 (AWS) every 4 days (just like @Paula Silveira suggested). 
You can find and use the script from here:

https://github.com/datreeio/jira-backup-py