x360Sync stores user data in buckets, called roots. Every type of data lives within a root, including:
- Personal root, which stores a user’s personal files and folders
- Team Share root, which stores Team Share files and folders
- Backup root, which stores a user’s backed up files and folders
Backing Up the x360Sync Server
As a private cloud partner, it is recommended that you back up various components of your system. For more information, please reference the Backing Up the x360Sync Server Knowledgebase article.
In the event of data loss or data corruption (for example, an advanced Ransomware attack) you can recover root data by restoring the root’s file store (raw binary data) and root store (metadata) from the exact same point in time using your backups.
Note: SaaS partners should contact Axcient Support to recover roots.
Step 1: Determine the Roots that Need to Be Restored
- In the administrative web portal, navigate to the user account, Team Share, or backup that needs to be restored (the affected root).
For example, to find an affected Team Share, click the Shares tab, and then click the Browse button next to the appropriate Team Share. You will be redirected to the end user’s view of the Team Share.
- Capture the URL of the root (for example, https://my.syncedtool.com/files/21).
The URL takes the form of: https://[application server]/files/[root subscription id].
Using the URL, locate and record the root subscription id (in this example, 21).
Note: If you need to restore multiple roots, you must find the root subscription id for each affected root.
Step 2: Convert the root subscription id Value to a Hex Value
Root store databases and file store data are stored in files and folders that use a hex value. To find the root database in the root store, and the files in the file store, you need to convert the root subscription id value to a hex value.
- Open the Calculator program.
- In the Calculator toolbar, click the View menu, and then select Programmer. The Calculator program will now display in Programmer mode.
- With the Dec radio button selected, enter the root subscription id value.
- Click the Hex radio button to view this number in Hex format.
- Use this number to find the file store folder and root store database file.
For example, if the root_id value is 21, then the Hex value is 15. The file store folder and root store database will end with this value. For example:
File store example path: D:\filestore\files\000\00000015
Root store example database: D:\x360Sync Server\store_1\roots\000\00000015.db
Step 3: Restore Data
Note: The file store data and the root store database must all be from the same point in time.
- Rename the old file store folder and the old root store database file to retain a copy.
- Replace the file store data with the data from your backup. If copying data from multiple file stores, data must be placed in the same respective file store location.
- Replace the root store database(s) with the database from your backup. Remember that this backup must be from the same point in time as the file store data.
Step 4: Rebuild Stats for the Affected Roots
When this data has been restored, stats need to be rebuilt for the affected roots.
- Open an elevated CMD prompt and navigate to [target drive:]\x360Sync Server\bin (the path to which you installed the x360Sync Server).
- Run the following command to review options:
- In most instances, you will first run the command with the -n flag to review the output and understand what will be updated:
stats_mgr -r ID -n --db-password PASSWORD
Note: Make sure to replace PASSWORD with your PostgreSQL password, and ID with the root_id value you recorded earlier. Your PostgreSQL user password is listed in the [portal] section of your x360Sync config.ini file ([target drive]:\x360Sync Server\conf\config.ini).
- Run the command again without the -n flag to commit the changes:
stats_mgr -r ID --db-password PASSWORD