web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Large size Database re...
Finance | Project Operations, Human Resources, ...
Answered

Large size Database restoration from prod to SAT

(0) ShareShare
ReportReport
Posted on by SayanikaSM

Hi 

Can you please help me with the following query:

A customer is trying to restore the production database (600GB) to SAT (tier 2).

 

As per licensing guide there is a specific size limitation for tier 2 environment. So can you please help to understand what will be the process to restore? Will he need to purchase additional database space for SAT or needs to upgrade the tier of the SAT environment ? Has this to be done through a support request?

Is there any documentation on tier2, tier3, tier4 etc  environment specification and database size?

Regards

I have the same question (0)
  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,025 Super User 2025 Season 2 on at

    Hi Sayanika,

    I'm not a licensing expert on the file size limits. Probably, you can reach out to your partner or Microsoft for the pricing question.

    There is documentation about the environments on this page: docs.microsoft.com/.../environment-planning

  • Verified answer
    Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,093 on at

    Hi Sayanika,

    From a restoring point of view, databases up to 1Tb should be restored without any issues (it's a limitation of Max storage limitation for P1-P6 Azure SQL databases). If you need to restore the database bigger than 1Tb, you will need to settle this question with MS as they need to increase Azure SQL tier level temporarily.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 611 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 529 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 285 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans