Mirroring cannot be restarted after stop

[cfccai]

hello 

As below pic shown, after I stop the replication. The 'Start replication' button is set to unavailable.

But somehow I remember that last week I am able to restart the replication after I stop replication.

So is there any change of Mirroring recently?

[v-nikhilan-msft]

Hi @cfccai 
Thanks for using Fabric Community.
At this time, we are reaching out to the internal team to get some help on this. We will update you once we hear back from them.
Thanks 

[v-nikhilan-msft]

Hi @cfccai 
The internal team replied as follows:

Its really hard to tell what's going on with out any context. We need details about the source, what tables they selected (all or a subset) - if they click on configuration - what do they see? If this is Snowflake, its possible to set it up badly, it looks all okay, and when you get to this screen things dont work.

Can you please provide these details?

[cfccai]

hello,

I am trying to mirror data from Azure SQL database. The function was working well during in the past. Recently I stopped the repilication since I want to config the replication. I click the Configure replication buttion of mirroring interface as below pic. and I choose some of the tables, and unclick some of the tables, then click Apply Changes button.

So I see the screen like below:

It shows me 'Mirrored Azure SQL Database is stopping.'

and buttons of Start replication, stop replication, and monitor replication is set to unavailable.

[v-nikhilan-msft]

Hi @cfccai 
Can you try to create a new mirrored database going to this same source? If it says the SQLDB is already Mirrored, run this on the source sql db:
EXEC sys.sp_change_feed_disable_db
Try this and let me know.
Thanks

[cfccai]

I created a new mirrored database with same data source. And it successfully created. And I can monitor the status like below:

[v-nikhilan-msft]

Hi @cfccai 
It can take a while for mirroring to kick in
Announcing Mirroring Azure SQL Database in Fabric for Public Preview | Microsoft Fabric Blog | Micro...
Under Key features, there are some DMV's to run. exec sp_help_change_feed; is the most important. It tells us what Azure SQL DB is doing.

[v-nikhilan-msft]

Hi @cfccai 
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. Otherwise, will respond back with the more details and we will try to help.
Thanks

[v-nikhilan-msft]

Hi @cfccai 
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. Otherwise, will respond back with the more details and we will try to help.
Thanks