Error setting up restored database

[ciezbit]

backed up and restored SQL Server database from previous installation on a different Windows Server 2012 VM.

Specified SQL Server connection, test connection succeeded.

database setup results in the following error at

http://localhost:8080/setup/setupdbtype.action

below is a link to the content of a log file located in 

C:\Program Files\Atlassian\Confluence\logs

confluence120218142942-stderr.2018-02-12.log

[AnnWorley · Accepted solution]

Thanks for the log file and description of the issue.

Because you are using a database backup from an existing instance, it sounds like you are working on either  Migrating to Another Database or Restoring a Test Instance from Production. Either way, you do not need to run through the setup wizard. The setup wizard runs when Confluence starts up and does not find the confluence.cfg.xml file in the Confluence home directory specified in the following file: <confluence_install>/confluence/WEB-INF/classes/confluence-init.properties. If you continue with the setup wizard it can overwrite the database back-up you made with blank Confluence tables.

To restore your instance on a different server the home directory also needs to be restored, and the database connection edited to "point" to the backed up database instance, as described in Migrating to Another Database:

If you are moving your database from one server to another you can change the JDBC URL in <confluence-home>/confluence.cfg.xml (if you are using a direct JDBC connection) or in the definition of your datasource (if you are connecting via a datasource).

Please review the docs, let us know how it goes, and how we can help.

[ciezbit]

Hi Ann,

Thank you very much for your reply.

There were a few steps we needed to take:

1. give SQL user db_owner permissions
2. when prompted, recreate the database, overwriting the restored database
3. copy confluence.cfg.xml file to the new server
4. backup sites & spaces on the old / source server
5. restore sites & spaces to the new / target server

it works now  :)

Thank you kindly

[AnnWorley]

Thank you for following up to let the Community know how you resolved it. Cheers!