Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Database Refresh to Tier2 Environment Occasionally Takes FOREVER

(0) ShareShare
ReportReport
Posted on by 5

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.."

  • Anton Venter Profile Picture
    19,545 Super User 2025 Season 1 on at
    RE: Database Refresh to Tier2 Environment Occasionally Takes FOREVER

    Hi,

    I know how you feel, I have experienced this kind of situation many times before. In most scenarios, using a recent database, that's maybe a few days or weeks old, is good enough because the scenario can be tested or reproduced using the data from production in a non production environment. Can you explain why a new backup is made first?

  • Komi Siabi Profile Picture
    12,789 Most Valuable Professional on at
    RE: Database Refresh to Tier2 Environment Occasionally Takes FOREVER

    Hello arcadefreaque,

    Something which unknown to me must have triggered the long delay in the database refresh action.

    Could you confirm if there have been any update recently on UAT or PROD?

    Are both environment, currently on same version?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,278 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,011 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans