Attachment migration SQL Server

[Jarek Grabski]

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?

[AlysonA · Accepted solution]

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!

[Rodrigo Girardi Adami]

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 :)

[Jarek Grabski]

Hi Rodrigo,

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