5
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,
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.
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
#1
André Arnaud de Cal...
293,150
Super User 2025 Season 1
#2
Martin Dráb
231,895
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
