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

(1) Share

Report

Posted on by Retha

1,461

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?

I have the same question (0)

All responses (3)

Answers (0)

André Arnaud de Cal... 303,730 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Retha,

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

Was this reply helpful? Yes No
AR-01121610-0 4,971 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Martin Dráb 239,040 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No