Skip to main content

Notifications

Microsoft Dynamics AX forum
Suggested answer

Management Reporter DB restore issue

Posted on by 530

Dear's,

I have an issue that i taked Management Reporter DB & DataMart DB backups then i have installed MR in a new server , i tried to restore those DB's but MR is not working after restore , How i can restore the desigened reports and security rolse and users from that DB files 

Categories:
  • ahmed.kimo Profile Picture
    ahmed.kimo 530 on at
    RE: Management Reporter DB restore issue

    Hi André,

    This is what happened with me , but when i reastored MR DB MR not working at all,

  • ahmed.kimo Profile Picture
    ahmed.kimo 530 on at
    RE: Management Reporter DB restore issue

    Hi,

    No , i did not exported form the building blocks, i just taked DB backup from SQL .

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Management Reporter DB restore issue

    Hi ahmed.kimo,

    Have you exported the reports before through the building blocks form in the MR?

    Best regards,

    Ludwig

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 290,142 Super User 2024 Season 2 on at
    RE: Management Reporter DB restore issue

    Hi Ahmed,

    In this case, you can better create a new setup and datamart database and restart the initial load. If you try to use a backup, the transaction data might be incomplete.

Helpful resources

Quick Links

Dynamics 365 Community Update

Welcome to the inaugural Community Platform Update. As part of our commitment to…

Dynamics 365 Community Newsletter - August 2024

Catch up on the latest D365 Community news

Community Spotlight of the Month

Kudos to Mohana Yadav!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,142 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 227,979 Super User 2024 Season 2

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans