URGENT: Confluence Restore

[Admin]

Hi, We have a Confluence site with a database siting onto a remote SQL Server 2014.  The Confluence VM corrupted (Windows 2012 R2) and we want to recover it.  

It tried to juste reinstall the application but when I'm pointing to the SQL Server database, it wants to erase it.

Please, could you give me restore instructions.

Thanks

Michel

[AnnWorley]

You can get the build number from the confversion table (select buildnumber from confversion;) and cross reference with Confluence build information or you can check the <confluence_home>logs/atlassian-confluence.log for the last entry of "Starting Confluence" because the version will be on the startup line.

[Admin]

Thanks Nic... is there a way to get, from SQL Server, what was the installed version ?

[Nic Brough -Adaptavist-]

Unfortunately, no.  There is a build number in it, but I don't know how to turn that into a version.

Do you have any of the damaged system left?  There's usually things in there that can help.

[Nic Brough -Adaptavist-]

The installation process expects to be connected to an empty database, not one with data in it.

Create a new empty database and run the installation against that.  This gives you a working but empty Confluence.  Make sure it's all working for you then stop it, go into the Confluence-home directory and edit the confluence.cfg.xml file - find the connection details for the new database and change them to the old database. 

Restart Confluence and then re-index it.