Restore SQL files to new SQL 2014 DB?

Hello, The VM running our Confluence instance completely crashed. We do have a backup of the SQL Express 2012 database (.mdf and .ldf files, the SQL_Data folder) - I'm hoping this is enough to restore our wiki. I have a new Windows 2012 R2 built with SQL 2014 fully patched and ready to go. Confluence is not yet installed as I was unsure what the next steps are.Curious if this is even feasible?

2 answers

0 vote
Chuck Talk Atlassian Team Jul 15, 2015

Hi IT Admin,

I do not know if the MSSQL Express 2012 will restore into SQL Server 2014 directly, but the procedure to Migrate Confluence Between Servers does provide the steps to do what you are seeking to do. Specifically, read the section entitled  'Transferring Confluence to Another Server using the Same Operating System' as that has the specific steps required to migrate your instance of Confluence using a backup.

I do hope that helps.

Chuck

0 vote
Daniel Eads Community Champion Jul 15, 2015

In addition to the Confluence installation directory, there's data stored in two more places:

  1. Database - this is where all the user info, pages, spaces, etc. are stored. Sounds like you have that under control (although MS SQL is pretty terrible with all Atlassian products, consider moving to MySQL/PostgreSQL if that's available to you and somebody in your organization can support those databases)
  2. Confluence Home - where the database configuration file is, the application logs, and all of your attachments. If you can't recover this directory, all the file uploads (images, PDFs, etc) that people have included on pages will be gone. This is typically near the same place as your Confluence install directory - for instance on Windows if Confluence was installed to D:\Confluence, you might find the home directory in some place like D:\ConfluenceData.

Hopefully you can recover the disk image of where the Confluence/Confluence Home directories were, or you will have a rough time coming back. Good luck!

 

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 Monday in Confluence

Calling all marketing teams who use Confluence - we want to hear from you!

Hi Community! me again 🙂 If you’re a marketing team using Confluence, we want to hear your story! How did you start using Confluence? What are your use cases? What have been some of the benefits?...

182 views 3 3
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