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

This widget could not be displayed.
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

This widget could not be displayed.
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
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Published Tuesday in Confluence

Add-on evaluation with confluence templates

Atlassian market place contains number of Apps/Addons which improves the capability of out of the box Atlassian products. It is good to follow a plugin evaluation process before install add-ons. So t...

109 views 12 6
Read article

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