Finance | Project Operations, Human Resources, ...

Financial Reporting Database is too large

(0) Share

Report

Posted on by JoshuaRamaditya

135

Hi All,

We have some issue on financial reporting database, it's grow too large. that's affect to our storage is full.

can we do anything to make the financial reporting mdf files is decreasing?

thank you

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

Sergei Minozhenko 23,095 on at

Like (0)

Report
Copy link

Link copied!

Hi Joshua,

If it's production DB, you need to create a support request to MS to handle this issue.

In sandbox\devbox environment, you can try to do offline index re-build for all tables in database and shrink database and files (only in devbox).

Was this reply helpful? Yes No
André Arnaud de Cal... 304,774 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Joshua,

Are you using Microsoft Dynamics 365 or is your question related to another version? If Dynamics 365, is it in the cloud or on-premise?

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi,

In D365FO, financial reporting database shouldn't grow that much!! This could be a result of multiple data mart integration failures. Tables like Datamart.Fact and Datamart.FactAttributeValue gets backed up at the start of the "Reset data mart" operation. IF this operations is not completed successfully, these backup tables are accumulated in the database overtime. (stored procedure [Datamart].[SaveAndDropAttributeValueIndexes])

I would suggest you to backup the database (for a safe side) and find out if there are any backup tables in the database and delete them if any. Perform a Reset data mart operation and make sure it is completed successfully.

Was this reply helpful? Yes No
Suggested answer

Navneeth Nagrajan 2,613 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello Joshua,

The suggestion is to shrink the .mdf file through the Shrink Database option in SQL Server.

Thanks,
Navneeth Nagrajan | Dynamics 365 Technical Consultant

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Joshua,

Before trying to shrink the database, I would like to recommend and follow what Sergei mentioned - get into contact with the MS support to get some help here. Otherwise you run the risk that there will be issues with your financial reports and data that you get.

Can you also share some details about the actual size that you referred to and how the financial / management reporter has been installed?

Best regards,

Ludwig

Was this reply helpful? Yes No