So you can restore Deployment Manager in case of a problem, you should back up Deployment Manager's configuration, data, history and package feeds. To do this:

1. Back up Deployment Manager's database
2. Back up the Red Gate Deployment Manager database encryption certificate
3. Back up the package feeds

1. Back up the Deployment Manager database

Deployment Manager uses a RavenDB database to store its configuration, data and history. By default, Deployment Manager backs up this database every 24 hours to the location set on the Backup Settings page (by default, C:\ProgramData\Red Gate\DeploymentManager\Data\Backups).

To change Deployment Manager backup settings:

1. In Settings, click Database backups > Change backup settings.

2. Use the Backup Settings page to:
   
   • Change the folder the database is backed up to
   • Change the backup schedule
   • Disable automatic backups (not recommended):
   

We recommend you move the backup files to a different server from the server running Deployment Manager.

2. Back up the Red Gate Deployment Manager database encryption certificate

Deployment Manager uses public/private key cryptography to encrypt SQL Server passwords and masked variables in its database so that only the Deployment Manager Windows service can read them. The keys are stored in a certificate named Red Gate Deployment Manager database encryption and kept in the Red Gate Deployment Manager certificate store which is in the Windows Certificate Store.

So you won't lose access to the encrypted data, export a copy of the certificate and save it to a secure location:

Set up the Certificates Snap-in in Microsoft Management Console

1. Click the Windows Start button, type mmc, and press Enter to open Microsoft Management Console.

2. Click File > Add/Remove Snap-in.
   The Add or Remove Snap-ins dialog is displayed.
3. Select Certificates from the list of available snap-ins and click Add.
4. Select Computer account and click Next.
5. Accept the default: Local computer, and click Finish.
   The Certificates snap-in is selected:
   
6. Click OK.

Export the certificate

1. In the Certificates Snap-in, expand Certificates (Local Computer) > Red Gate Deployment Manager > Certificates
2. Right-click the Red Gate Deployment Manager database encryption certificate and click All Tasks > Export:
   
3. Click Next.
4. Select Yes, export the private key and click Next.
5. Accept the default: Personal Information Exchange - PKCS #12 (.PFX), and click Next.
6. Set a password and click Next.
   You'll need this password to import the certificate into a new server if you restore Deployment Manager.
7. Specify a path and file name for the .pfx file. This file will be created and the certificate will be exported to it. Click Next.
8. Review the settings and click Finish.

We recommend you move the .pfx file to a different server from the server running Deployment Manager.

3. Back up the package feeds

If you're using the Deployment Manager package feed, we recommend you take regular copies of the feed folder where the packages are stored.

If you're using package feeds other than the Deployment Manager package feed, refer to the documentation from the software provider for how to back them up.

Restoring Deployment Manager

To restore Deployment Manager to a new server, do the following:

1. Install Deployment Manager
2. Restore the Deployment Manager database

3. Restore the Red Gate Deployment Manager database encryption certificate

4. Restore the package feeds
5. Activate Deployment Manager
6. Check the configuration has been restored successfully

1. Install Deployment Manager

Before you can restore the data and settings from your previous installation, you first need to reinstall the Deployment Manager application. To do this:

1. Download the free Starter Edition of Deployment Manager from the product page.
2. Follow the instructions in Installing up to step 10.

Existing user accounts will be restored to the new server; you don't need to set up an administrator account after installing.

2. Restore the Deployment Manager database

To restore the database from a backup, use the Raven.Smuggler command line tool included with Deployment Manager:

1. Find the most recent backup file to restore.
2. Copy the backup file to the server running Deployment Manager. Make sure the Red Gate Deployment Manager service is running.

3. Start a command prompt as administrator. Change directory to the Server folder in the installation folder of Deployment Manager.

   By default, the installation folder is C:\Program Files (x86)\Red Gate\Deployment Manager

4. On the command prompt, run:
   Raven.Smuggler in http://localhost:10300 <path to backup file>

This will restore your user accounts, configuration, projects and history.

3. Restore the Red Gate Deployment Manager database encryption certificate

To restore the certificate, delete the existing certificate on the new server, then import the .pfx file using the Certificates Snap-in so that it's in the the same location as the previous certificate. To do this:

1. Make sure the .pfx file is accessible from the new server.
2. Open the Certificates Snap-in on the new server (see Set up the Certificates Snap-in in Microsoft Management Console above).
3. In the Certificates (Local Computer) > Red Gate Deployment Manager > Certificates folder, right-click the Red Gate Deployment Manager database encryption certificate and click Delete.
4. Right-click on the Certificates (Local Computer) > Red Gate Deployment Manager > Certificates folder and click All Tasks > Import.
5. Click Next.

6. Specify the name and path of the .pfx file (see the Export the certificate section above), and click Next.

7. Type the password you set in step 5 of the Export the certificate section above, select Mark this key as exportable and click Next.

8. Accept the default: Place all certificates in the Red Gate Deployment Manager certificate store, and click Next.
9. Review the settings and click Finish.

4. Restore the package feeds

If you're using the Deployment Manager package feed, copy the contents of the feed folder you backed up to the Data\feed folder in your new installation.

If you're using package feeds other than the Deployment Manager package feed, refer to the documentation from the software provider.

5. Activate Deployment Manager

If you have a licensed copy of Deployment Manager, do the following:

1. Log in to Deployment Manager with an administrator account.
2. On the Settings page, click Licensing.
3. Under Serial number, enter the serial number and click Activate.

6. Check the configuration has been restored successfully

Check the Environments, Projects, SQL Servers, target machines, package feeds and deployment history have successfully been restored.

If you have any problems, contact support.