Finance | Project Operations, Human Resources, ...

How to reduce the DB Size and CleanUP MR Tables

(5) Share

Report

Posted on by Sophs@4Sight

267

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 (5)

Answers (0)

Sort by

Suggested answer

Hana Xue Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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 267 on at

Like (0)

Report
Copy link

Link copied!

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-26050414-0 7 on at

Like (0)

Report
Copy link

Link copied!

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
PK-23121628-0 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @Sophs@4Sight, did you ever figure this out? We are experiencing large MRDB table sizes as well.

Was this reply helpful? Yes No
CU16030945-1 2 on at

Like (0)

Report
Copy link

Link copied!

Hi

Has someone an update for this ? We are experiencing large MRDB table sizes as well.

Was this reply helpful? Yes No