Notifications
Announcements
No record found.
Now I use AX2012. I Found about Some Database is big. This database name is AX_MR_Test_Primary.mdf .
I want to reduce size. And There many database in my database. I want to delete it.
Thank you
apichai
Hi Apichai,
According to the modified date and time, this database is in use, and based on name (MR) I think it's management reporter DB and you can't just delete it.
It could be that the DB is highly fragmented and you can reduce DB size by performing the next steps in SQL management studio for the database (don't forget to make a backup before completing steps):
1. Rebuild all index in DB (for example www.mssqltips.com/.../)
2. Shrink DB docs.microsoft.com/.../shrink-a-database
3. Shrink file docs.microsoft.com/.../shrink-a-file
The database is indeed related to Management Reporter (MR). Which exact version of MR are you using? In the past there was an issue where the database size could be too large. Check if you are running the latest version. If not you can update MR, delete this database and create a new datamart.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 456 Super User 2025 Season 2
Martin Dráb 429 Most Valuable Professional
BillurSamdancioglu 239 Most Valuable Professional
