Backup of Decisions Database and File System
- 29 Mar 2022
- 1 Minute to read
- Print
- DarkLight
Backup of Decisions Database and File System
- Updated on 29 Mar 2022
- 1 Minute to read
- Print
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback
Overview
In instances that involve any update or alteration to an installation, it is important to backup all Flows, Forms, Portal settings, etc that are stored within the Decisions Database to avoid data loss. Doing so ensures that all files can be accessed in the event of potential errors that may occur during installation, such as a database overwrite, and offers a point of restoration for the database.
The following document demonstrates how to back up an MS SQL-based Decisions Database, as well as any applicable or desired Settings, Modules, and Encryption Files.
Warning!
This backup process can only be performed on Microsoft SQL (MS SQL) databases.
Backing up Decisions Database
- From the Local File System, Open Microsoft SQL Server Management.
- Enter the Login and Password for the Server and click Connect.
.png)
- From the Object Explorer on the left, navigate to Databases > [NAME OF DATABASE]. Then, right-click the Database and select Tasks > Back Up.
- From the Back Up Database window, under Source, select a Backup type from the dropdown menu. Then, under Destination, click Add and select the desired location for the Backup, and click OK.
.png)
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.
Installer Archiving
In addition to backing up the suggest files below. as well as the database, the Decisions Installer used to set up the machine should be archived to allow for easy reinstallation in the event of Disaster Recovery.
| Name | Location | Description |
|---|---|---|
| File Storage Files | C:\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" File | C:\Program Files\Decisions\Decisions Server\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" File | C:\Program Files\Decisions\Decisions Server\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 Files | C:\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. |
For further information on Administration, visit the Decisions Forum.
Was this article helpful?
