Forum Discussion
Mirroring cannot be restarted after stop
Hi Anonymous
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?
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.
Hi Anonymous
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.
ThanksI created a new mirrored database with same data source. And it successfully created. And I can monitor the status like below:
Hi Anonymous
It can take a while for mirroring to kick in
Announcing Mirroring Azure SQL Database in Fabric for Public Preview | Microsoft Fabric Blog | Microsoft Fabric
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.