Restore Backup DB

Recently We lost our AWS machine that Octopus Deploy was running on. However, we were able to retrieve the DB backup and the configuration folder where Octopus Deploy was hosted on.

We are trying to restore the DB to a new machine with the same version as the previous octopus deploy i.e. 3.3.2. It seems the DB does not recognize the master key we have. It seems like we do not have the right master key. Can you please help us if there is way to restore Octopus Deploy DB and files without having the right master key?

Regards,
Sujit

Hi Sujit,

Thanks for getting in touch! I’m saddened to hear about your experience - this is not a good situation to be in.

If you saved a copy of your master key, you should be able to use that when you set up Octopus Server on a server and point it to an existing Octopus database.

If you don’t have a reliable copy of the master key, is there any way you can stand up a new EC2 instance using the same disk as the original? That would be the next best way to recover. The Octopus Server should just start up and be happy, or otherwise we should be able to get the master key from that EC2 instance.

If none of these options are workable, the best possible option we have left is to reset your master key and scrub all your secrets. You’ll have to re-enter all your secrets again, but at least you’ll still have everything else.

Here is a detailed page describing how to recover in the worst scenario: https://octopus.com/docs/administration/lost-master-key

Hope that helps!
Mike

Thank you Mike for providing the link to lost master key article. You are amazing. We are able to retrieve most of the project work except keys and passwords of course.

Regards,
Sujit

Hi Sujit,

Oh wow, so you’re up and running again! Nice work. :slight_smile:

Happy Deployments!
Mike