Question: Restore from live to sandbox on difference host. Is it possible

You could try the below using the command line, this has help me out on a few occasions and is based on the post below:

bin/cake settings set PUBLIC_ADDRESS https://yourerambadomain.com