Azure SQL Mirror Issue

[jadler]

I was able to successfully mirror an Azure SQL DB wonderfully. However, I had to delete the mirror as I wanted to move the workspace it was in. After trying to mirror again in the new workspace I keep getting the below error even aftrer 24 hours of waiting. Any Suggestions?

[v-saisrao-msft]

Hi @jadler 
Could you please confirm if the issue was resolved after raising a support case? If so, we’d appreciate it if you could share the solution to help others in the community. As we haven’t heard back, we’re closing this thread. For any further issues, please start a new thread in the Microsoft Fabric Community Forum we’ll be happy to assist.

Thank you for being part of the Microsoft Fabric Community.

[v-saisrao-msft]

Hi @jadler,

Could you please let me know if you have raised the support ticket and whether the issue has been resolved? If it has been resolved, please provide the insights to help community members who are facing a similar issue. Kindly accept your reply as a solution.

Thank you.

[dlauth33]

That happened to me as well.  I had to open a support ticket to have replication broken from the backend.

[jadler]

Awesome thanks for that, will get in touch with them. Seems crazy, but I guess this platform is still fairly new. 

[v-saisrao-msft · Accepted solution]

Hi @jadler,

Thank you for reaching out to the Microsoft Fabric Forum Community. 

Are the queries suggested by @dlauth33, running? If please raise a support ticket so one of the engineers can assist in rectifying the issue. Below is the link to raise the support ticket: 
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

Please refer to the document link below: 

Troubleshoot Fabric Mirrored Databases - Microsoft Fabric | Microsoft Learn.

If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

Thank you. 

[dlauth33]

Here are a couple of queries you can run against the source db of the mirror that support will ask for.

SELECT * FROM sys.dm_change_feed_log_scan_sessions;
--if mirroring is actually stopped I think this table should be empty

SELECT * FROM sys.dm_change_feed_errors;