As an MSP we have multiple data centers with many remote probes. We know that remote probes will not switch over automatically to a backup core server so in order to achieve redundancy we are contemplating setting up a secondary standby core server in a backup data center and several times a day backing up the main core server to the secondary location.
When we need to switch to the secondary site we are thinking of restoring the database from backup and then changing the IP address associated with the remote probes so that they now point to the secondary data center server.
So my question is... of course will this work? Are there any gotchas we may have missed? Do you have anyone already doing this? Is there a better option?