Database Optimizatio in NAV 2009

sakameeransakameeran Member Posts: 52
Dear Experts,
We have some clarification / support / guidance on Microsoft Dynamics NAV Database Optimization,
1) Our Current Microsoft Dynamics NAV database size is around 250GB, due to this huge database size we are facing issue with Backup Management System / Performance. Even it is increasing every month 10 GB (approx.).
2) For reducing the database size shall we use “NAV Optimize option” (File-> Database ->Information -> Tables ->Optimize)? Is this the best solution? Is there any impact after in using this optimization activity?
3) For your information, we made a test database base and did this optimization activity and reduced the database size from 250GB to 180GB (around 70 GB reduced).
4) Expecting your valuable suggestions / advise / solution.


S.A.K.Ahamed Meeran


Sign In or Register to comment.