Upgraded to 6.15.1 - SQL Errors - How do I revert back to 6.14.1?

Question

We recently installed Confluence 6.14.1 using SQL server 2008 R2.  There were no troubles reported and everything appeared to be working fine.  There is now a lot of data entered into the system.

I recently installed the upgrade to 6.15.1 and it appeared at first to be working fine, but then we noticed issues with an SQL error about an invalid datatype in the logs and various functions were not working.  In troubleshooting I noticed that SQL 2008 R2 has not been supported for some time.  Since the previous version was working, we want to revert to that version to have it working while we plan for an SQL upgrade.

I have renamed the new folders and restored the zip file backups.  It appears that the SQL database was never upgraded (as per the logs I mentioned above it says the schema could not be updated).  I cannot find any instructions about how to revert a failed upgrade.  Please advise.

Nic Brough -Adaptavist- · Answer

It depends on what backups you took - an xml backup can be restored directly into a new empty system, or a database/file-system one can be restored over the top of a working empty Jira.

Ernie Jennings · Answer

@Nic Brough -Adaptavist-  Sounds great Nic, can you elaborate please? I need to revert back to a previous version. Can you provide a link or steps to this process?

Nic Brough -Adaptavist- · Answer

There is no "revert" process - you have to go back to the backups you took before you upgraded.