Backup of Decisions Database and File System
  • 08 Jan 2021
  • 1 Minute to read
  • Dark
    Light

Backup of Decisions Database and File System

  • Dark
    Light

Article Summary

Overview

In instances certain instances, such as updating or reinstalling Decisions, it is important to backup all Flows, Forms, Portal settings, etc that are stored in the Decisions Database. Users should back up their database to prevent data loss under any circumstance. The following tutorial covers how to back up a Decisions database.

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



Backing up Decisions Database

  1. Open MS SQL Server Management.
  2. Enter the Login and Password for the Server and click Connect
  3. Navigate to the Database for backup. 
    1. Right-click and select Tasks > Back Up
  4. From the Back Up Database window, under Source, select a Backup type from the dropdown menu.
    Users are offered the option to either do a Full or a Differential backup. 
    1. Under Destination, click Addand select where the backup will be saved to. 
      Users have to option to select a Disk or a URL source for the Destination.
  5. Click OK



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. 

It is also a good idea to archive off the Decisions installer that was used to set up the machine to easily reinstall when recovering from a disaster.
NameLocationDescription
File Storage FilesC:\Program Files\Decisions\FileStorage\*This contains any files that have been added to the portal such 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 Server\Instances\Control\Keys.datThis 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 Server\Settings.xmlThis 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 Server\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.




Was this article helpful?