Hi,
Our change log entry table was around 40GB so we started fresh and truncated the table via SQL command.
After this was done, the database size statistics has not reduced and still shows the same usage? What can we do in NAV or SQL to clean up the database? Would a reindex help and if so how do we trigger this?
*This post is locked for comments
Hi,
Scroll to the section Revert entries in this blog stoneridgesoftware.com/changes-to-microsoft-dynamics-nav-change-log-system-how-to-revert-its-behavior
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156