best way to delete 200 million change log entry records in D365 BC on Prem version

(1) Share

Report

Posted on by SM-05060705-0

what is the best way to delete 200 million change log entry table records in D365 BC on Prem version
1. SQL
2. Application manual deletion
3 Retention policies
4 configuration packages
5 Excel add-in (I guess doesn't work on-prem version)

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Gerardo Rentería Ga... 27,545 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi I hope it gives you some ideas.

Change Log Entries clean up (dynamics.com)

BR

GR

Was this reply helpful? Yes No
Suggested answer

Dynamics_Decoded_Gokul 487 on at

Like (0)

Report
Copy link

Link copied!

Hi,

My Opnion on this would be using SQL query to clean up.

Setting up retention policies for the future entries would redeuce the log deletion performance

Thanks
Gokul

Was this reply helpful? Yes No
Suggested answer

Valentin Castravet 32,800 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

SQL would be the fastest by far, after that running report 510 in the job queue in BC or retention policies. Configuration packages/excel would be painfully slow.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/

Was this reply helpful? Yes No