Management Reporter DB restore issue

(0) Share

Report

Posted on by ahmed.kimo

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

*This post is locked for comments

All responses (4)

Answers (0)

ahmed.kimo 530 on at

Like (0)

Report

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 530 on at

Like (0)

Report

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 Microsoft Employee on at

Like (0)

Report

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 Cal... 291,280 Super User 2024 Season 2 on at

Like (0)

Report

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.