Critical Server Files and Settings to Backup
Version:
2022.1
Last modified: January 27, 2023
The files and settings mentioned in this article, along with a MongoDB Backup, allow you to reconstruct your Server's data and environment.
If you only have 1 node, ensure you gather all the information from that machine. If you are trying to establish a routine backup process, refer to the suggested script in Alteryx Server Backup and Recovery Part 2: Procedures (22642).
Place these files in a secure location and indicate the version of Server currently running. To find out which version you use, go to Alteryx Server, select My Profile in the upper right corner, and refer to Versions.
Note that you should adjust the drive and folder paths mentioned in this article based on your installation location.
All Nodes
| File | Location |
|---|---|
| RuntimeSettings.xml | C:\ProgramData\Alteryx\RuntimeSettings.xml |
|
Service Log On User
|
Windows Services app > right-click AlteryxService > Properties > Log On |
| Configuration File | Only need to backup if the file has been modified.
|
Controller Node
| File | Location |
|---|---|
| Controller Token | Alteryx System Settings > Controller > General > Controller Token or use the command line (run As Administrator): "C:\Program Files\Alteryx\bin\AlteryxService.exe" getserversecret |
| Mongo Passwords | Save both Admin and Non-Admin passwords: Alteryx System Settings > Controller > Persistence > Database or use the command line (run As Administrator): "C:\Program Files\Alteryx\bin\AlteryxService.exe" getemongopassword |
Worker Nodes
| File | Location |
|---|---|
| Run As User | Alteryx System Settings > Worker > Run As |
| This might not be used by your Server: | These are configured in Designer on your Server and users mirror them on their local Designer. Workflows developed locally using these Connections expect them to exist on the Server to run without error. |
| Shared DB Connections | C:\ProgramData\Alteryx\Engine\SystemAlias.xml This file is generated from Designer > Options > Advanced Options > Manage Database Connections. |
| In-DB Connections | C:\ProgramData\Alteryx\Engine\SystemConnections.xml This file is generated from Designer > Options > Advanced Options > Manage In-DB Connections. |
Additional Information Needed to Recover to a New Server
| File | Location |
|---|---|
| License Keys | Designer > Options > Manage Licenses |
| ODBC Drivers | ODBC Data Sources App > Drivers Supported Drivers: https://downloads.alteryx.com/ |
| DSNs | ODBC Data Sources App > System DSN |
| Connectors | Determine the list of Connectors installed on your Server. See the Server Upgrade > PLAN section Understanding Connectors. |
| Python Tool Environment | Save a list of Python packages, refer to How To Create a Text File for a Backing up Designer Python (757448). |
| Permissions | Active Directory groups that are granted access to local Server security policies. |