Forum Discussion
Advocate IAzure SQL Mirrored DB says "metadata tables are corrupted" when stopping then restarting replication
Advocate II have also raised a support ticket. Since what I was working on was just PoC I did not require a "then and there" fix. They have confirmed that the only way to fix is by "fiddling" behind the scenes and that end-users are in no position to solve the problem for themselves. I was assured that it has been escalated with the Product Team with no commitment to an estimated fix date. The lack of "traceability" leaves me feeling uncomfortable that the issue has not made it's way onto the official "known issues" list. All that the support desk could provide is verbal assurance.
As it stand I will not take Fabric Mirror anywhere near a production workload without a root cause fix!
Super UserI brought it up with the PG members (pointing them to this thread) and at least they seem to be acknowledging the issue now. Didn't sound like an easy fix though.