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

0 votes
Accepted answer

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 votes

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
Community showcase
Posted Monday in Confluence

Organizing your space just got easier - Page Tree Drag & Drop is here

Hi Community! I’m Elaine, Confluence Product Manager. You may have read my earlier post about page tree in space navigation sidebar. I'm excited to share another improvement that helps you organize ...

120 views 3 4
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