Backup of Decisions Database and File System
  • 20 Apr 2020
  • 1 Minute to read
  • Dark
  This documentation version is deprecated, please click here for the latest version.

Backup of Decisions Database and File System

  • Dark


All the Flows, Forms, Portal settings, etc are stored in the Decisions database. So backing up the Decisions database is the most important step. Backing up the Decisions database is very important for various reasons. Users should back up their database to prevent data loss under any circumstance. This tutorial covers how to back up a decision database.

This backup process is only for the Microsoft SQL (MS SQL) database.

Backing up Decisions Database

Navigate to MS SQL Server Management. There will be a "Connect to Server" window. Sign to connect to the database

Navigate to the database that needs to be backed-up. Right-click Tasks>Back-Up

This will open a "Back-Up Decisions Database" window.

This window has two main sections. The first section has the Source information. Here uses can specify the type of backup (Full or differential). The second section is the Destination section. Here Users can Specify where the database is going to be backed-up to. Users have to option to select a Disk or a URL source for the destination. Once the settings are configured users can click 'Ok' to start the backup process.

Important Files to Backup

In addition to the Decisions database, Users should also back up the following to ensure that a machine could be rebuilt entirely from backups. 

File Storage FilesC:\Program Files\Decisions\FileStorage\*
This contains any files that have been added to the portal as File References (FileData is stored in the database). If File References were not created, then
this folder may be empty.
"Keys.dat"  FileC:\Program Files\Decisions\Decisions Services Manager\Instances\Control\Keys.dat
This file contains the encryption keys to decrypt any encrypted database values. This file will not exist if users have not created any encrypted data
"Settings.xml" FileC:\Program Files\Decisions\Decisions Services Manager\Settings.xml
This file contains low-level settings about the server like connection string to the database, base URL to the portal, enabled logging levels.
Modules FilesC:\Program Files\Decisions\Decisions Services Manager\modules\*
This folder should be backed up if users have created any custom modules but do not need to be if users are only using built-in modules from Decisions.

It is also a good idea to archive off the Decisions installer that was used to set up the machine so that you can easily reinstall when recovering from a disaster.

Was this article helpful?