How to get a database backup and encrypt your master key

Last updated 2018-01-15T02:11:12.6928732+00:00

When you contact Octopus Deploy support, sometimes we aren't able to reproduce the issue you're experiencing. This can be due to specific circumstances in your instance, or corrupted data which we won't be able to reproduce. We may ask you to send us a database backup and your encrypted master key, which will allow us to accurately reproduce the issue and aid in resolving it. This guide provides a walkthrough to get the best information for us to help troubleshoot the issues.

Step-by-step guide

Create the database backup

The easiest way to import a database is to restore from a .bak file, and this is the format we will ask for. This can be produced from SQL Server Management Studio. Right-click on the Octopus database, and select Tasks > Back Up..., and select the directory where the .bak file will save to.

We have a PowerShell snippet which will encrypt your master key, using Public Key Cryptography so only Octopus can decrypt it. You can use this snippet to encrypt your master key, and when we receive it, we will decrypt it and use it to restore the database you have provided to us.

In your email or forum thread with Octopus support, we will provide you with a secure and private link to upload your database backup and the encrypted master key. Only we have access to view and download these files, and we will only allow upload access to you. We will also ensure your forum thread is marked as private if it hasn't already been, to ensure only you and our team can see the link.