nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to access content/data from a SQL Server .MDF file (+ error installing on local server)

Gary Schneider

Hello,

We have been subject to virus attack that destroyed our server, luckily we still have the SQL Server MDF file for confluence database!

Question 1: How can we recover the spaces and articles inside this MDF file?
Also,

I tried installing Confluence again, but give me error :

com.atlassian.util.concurrent.LazyReference$InitializationException: java.lang.IllegalStateException: Spring Application context has not been set
at com.atlassian.util.concurrent.LazyReference.getInterruptibly(LazyReference.java:149)
caused by: java.lang.IllegalStateException: Spring Application context has not been set
at com.atlassian.spring.container.SpringContainerContext.getComponent(SpringContainerContext.java:48)

Question 2: Can you assist on finalizing the installation process?

Please contact Mr Nabil Kemerchou: nkemerchou@hopitel.com for technical debugging

Regards,

Accepted answers

All comments

Nic Brough -Adaptavist-

My understanding of MS SQL is that you can't just plonk an MDF file in place and expect it to be a database in the new MS SQL server you've built

You will need to recover the data from the MDF (and, if memory serves, the matching LDF file) and then connect Confluence to the recovered database.

What have you done to recreate the database from the MDF file? Can you connect to the new database and see Confluence tables in it from a command line or database viewer?

Gary Schneider

As stated in my request, I tried to install Confluence again and it did fail with the message provided!

The MDF files itself can be attached to the database, and I can see all the data, the issue is how to connect a Confluence FrontEnd to the data.

So, do you think you can help us recover the original data from the MDF file ?

Nic Brough -Adaptavist-

It will give that message if the database is invalid, or any one of a hundred other problems. I focussed on the database because you started with the mention of an MDF file, which is irrelevant to Confluence - it only cares that there is a usable database (which an MDF file alone is not)

So, just to re-iterate - has your MDF and LDF files been converted back into a fully working database? Not "attached", but converted into a database?

Gary Schneider

Let me try to clearly it : to you question " has your MDF and LDF files been converted back into a fully working database? " the answer is no, and that exactly the purpose of the support request!

The MDF is the database (with the ldf which we also have)! not sure why you said it is not!? and attaching the MDF to the SQL Instance will give a fully functional DB from SQL server perspective! but again I am looking for a procedure to read the data from Confluence FrontEnd!

I'm having the impression that i'm repeating the same thing again, maybe having a quick call will clarify it for you

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server