web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... How to reduce the DB S...

Finance | Project Operations, Human Resources, ...

Suggested Answer

How to reduce the DB Size and CleanUP MR Tables

(3) Share

Report

Report

Posted on by Sophs@4Sight

223

Good morning

I have a client that did a DataBase restore from their Prod(Live) environment to the UAT (Sandbox) environment.

We did a number of cleanup processes, but the FnO DB capacity is still nearly 2TB big.

They want us to drastically reduce the size. Currently the top 15 Tables are all MR Tables.

I have tried Data mart reset for Financial reporting But this did not make any change on the size of the DB Capacity. https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/reset-financial-reporting-datamart-after-restore

How can I cleanup these Tables. See below some of the top largest tables

Any advice or assistance will greatly be appreciated.

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

Hana Xue Microsoft Employee on at

Like (1)

Report

Hi,
If you need to reduce the size of the database, follow the cleanup routine: https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/sysadmin/cleanuproutines
If there is no effective reduction, you can see if this document is useful: https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/database/export-database#maximum-limit-50-gb-on-exported-bacpacs

Best Regards,
Hana

Was this reply helpful? Yes No
Sophs@4Sight 223 on at

Like (0)

Report

Good day Hana Xue

Thank you for your response, but I have tried all these steps. But none of them address the MRDB Tables and we can not find any documentation on how to access them. Even using JIT access you only have view access to these tables and database.

Was this reply helpful? Yes No
JM-30041820-0 7 on at

Like (0)

Report

Hi @Sophs@4Sight, I understand that this post is quite old, but did you ever figure this out? We too are experiencing large MRDB table sizes.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

Martin Dráb 664 Most Valuable Professional

#2

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

#3

Sohaib Cheema 303 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans