web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Management Reporter up...
Microsoft Dynamics GP (Archived)

Management Reporter upgrades and SQL mirroring

(0) ShareShare
ReportReport
Posted on by Community Member

I just ran into an issue updating MR on a client's disaster recovery server.

I can't connect to the application service. I'm also receiving errors in the log, that I can't update the MR database because the database is part of a mirroring session.

We were able to get around this on the live server by turning off mirroring.

When mirroring is turned back on, and the MR database on the DR server refreshes, will that eliminate the need for updating the MR database?

Thank you.

*This post is locked for comments

I have the same question (0)
  • sueconrod Profile Picture
    sueconrod 337 on at

    No, the data will be refreshed but the application will still be the same.  You need to go back to the Client's disaster recovery server and update that server with the correct code.  

  • Community Member Profile Picture
    Community Member on at

    I should have clarified that we have updated the server and client code on the DR server.

     

    I want to know about the database holding the MR reports. Will mirroring transfer over the updated database from the live server, or do we have to update the MR database on the DR server?

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    If you are only talking about the code in the databases and not the underlying application code then the answer is yes.  The data is sent from the principal to the mirror.  So if the principal database is updated then the mirror will be updated to reflect those changes.  Below is a link to the Microsoft guide on how mirroring works if you want more detail on the subject.

    http://msdn.microsoft.com/en-us/library/ms189852.aspx

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans