Kosta the problem is only related to the database inconsistency, correct?
If you restore a snapshot backup for a busy Enhance server, you’ll end up with the main CP having no record of missing changes, new users added, removed, or canceled ..etc, leading to a complete mess that’s very hard to fix.
The best approach is to use a VM for your main CP and add as many dedicated servers to your cluster as you wish. For the main CP, rely on snapshot backups, and for other servers, if one goes down, simply deploy a new one and restore your websites from backups. In less than half an hour, you’ll have a fully replicated server with the same settings, thanks to Enhance’s clever unique backup system.