Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / How to shrink the data...
Finance | Project Operations, Human Resources, ...
Unanswered

How to shrink the database size on our Tier-2 sandbox environment

(1) ShareShare
ReportReport
Posted on by Retha 1,433

I need to get our UAT environment (tier-2 sandbox) to 50GB max to be able to export it to refresh our development environments.

I ran a bunch of the clean-up features including the database log and the data management history cleanup.

The database grew instead of shrunk. Which means there must be a lot of empty space.

I just upgraded the UAt environment via LCS in the hopes that the pre-servicing and post-servicing steps would have taken care of the fragmentation. But it didn't.

So do I need to log a ticket with Microsoft to run something to get rid of the blank space to get the actual size of the database or is there something that we can run ion UAT to fix it ourselves?

  • Martin Dráb Profile Picture
    Martin Dráb 230,414 Most Valuable Professional on at
    How to shrink the database size on our Tier-2 sandbox environment
    You can connect to the database through SSMS (after enabling access) and I'd assume that you can shrink the database from there. But maybe there is a problem that I'm not aware of André is.
     
    Also, the growth after deleting the data may be caused by Full recovery model. With this model, all changes are stored in the transaction log (therefore deletion of data increases the size of the log) until you backup the log.
  • andreasraithel Profile Picture
    andreasraithel 4,820 Super User 2024 Season 2 on at
    How to shrink the database size on our Tier-2 sandbox environment
    Hy,
    we have the same issue as production DB is ~ 1,5 TB.
    After DB refresh we delete and truncate a lot of not needed stuff, but DB size keeps as it as and the DB size will not decrease.
    In Devboxes we could reduce DB size to 600 GB. 
    Did you get responce from the MS about one time shrink of Tier 2 dbfiles?
     
    kr, Andreas
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,684 Super User 2024 Season 2 on at
    RE: How to shrink the database size on our Tier-2 sandbox environment

    Hi Retha,

    You can't manage the database size yourself. I would suggest you creating a ticket for Microsoft Support.

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,684 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,414 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans