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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (