We are running Cloud Hosted D365 Finance and Operations release 10.0.31 PU55, and are relatively new to administering/maintaining our systems (live since Dec last year). In order to deal with issues that come up with our live environment, we often are asked to restore a point in time copy of the live database to our UAT Tier2 Sandbox environment so that we can safely debug/try scenarios with the data in question. This process typically takes 50 minutes or less to complete, but on more than one occasion, the process has taken considerably longer - as in 10+ hours... one time it took 3 days.
Microsoft support has been useless in resolving this in a timely manner. If its not past the 48hr mark, they won't even talk. I find this ridiculous, as it impacts our ability to solve issues with our live system, and it leaves us in a precarious situation with a completely unusable tier2 environment for an extended amount of time.
Are there things that I should/could be doing to help make this process go more smoothly? (i.e. when doing builds there are certain quirks that crop up occasionally, so I always do a database sync, delete the backup directory, and reboot the build server first, which eliminates about 99% of our unnecessary build errors)
Are there tools available that would allow me to view what is going on with our system during this process and/or stop/restart it myself? (Since it's a Tier2 cloud hosted environment, we seem to be seriously limited, and once the restore starts, all of the maintenance options disappear from the drop-down)
As it sits, I'm starting to look like a moron to my users, as they request some assistance in resolving a production issue and I occasionally come back to them and tell them "eh... I dunno.. I can't do anything for you for a few days.."