Attachment migration SQL Server

We're about to migrate attachments from a SQL Server to file system. For having a really large database (about 40GB), this procedure takes about 2 days. After it is finished the attachments are stored twice: in home folder of confluence and still inside the database. Confluence is also still storing attachments in database and not on the file system.

Do anybody has exceperience with that large database and SQL Server? We didn't find any exceptions or errors in both log files (tomcat&confluence), so what could be the problem?

2 answers

1 accepted

Hi Jarek,

Unfortunately https://jira.atlassian.com/browse/CONF-9888 doesn't have an ETA at this time. For now we suggest that you vote on the bug report to increase its popularity so it can hopefully be included to the bugfix roadmap in the near future. I have voted as well. =)

Please let us know if you have further questions!

0 vote

Hi Jarek,

We have a known bug regarding huge attachments migration: https://jira.atlassian.com/browse/CONF-9888

Unfortunately is still not fixed, however some improvements were made in the version 4.1 onwards:

https://jira.atlassian.com/browse/CONF-15937

https://jira.atlassian.com/browse/CONF-23783

You may want to upgrade to the newest Confluence version to attempt those improvements. (Assuming that you are in an older version of Confluence). Hope that helps you :)

Hi Rodrigo,

thanks for replay. Actually we're planning an upgrade next year. Which version will include this bugfix?

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
Posted Jul 10, 2018 in Confluence

We want to see the templates you've created in Confluence!

Hi Community, Jessica here from the Confluence Product Marketing team!  July’s community challenge is all about sharing pictures  — and as an extension of our first post on what ...

551 views 20 11
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