Forum Discussion
Advocate IISchedule Fabric DB Mirroring
Hi chris__1 I haven't tested it, but I wonder if disabling and re-enabling the Azure SQL DB via exec sp_change_feed_disable_db would work.
Advocate II@whoever acceppted the solution: have you tested the suggested approach? Also my question was clearly regarding a Fabric feature (schedule for mirroring) as I would very much prefer solving this from within Fabric (as this is the tool I have access to - as opposed to the various DB I would like to mirror).
I am all in favour of having lots of threads with "acceped solutions" as this is clearly helpful for user seeking those solutions, but this seems counterproductive...
- AndyDDC
Most Valuable Professional
No idea who accepted as a solution. This is still pending.
Currently there is no way in Fabric of scheduling mirroring, it's a continuous process. I thought there might be API functionality to start/stop but it's only for listing (Items - REST API (MirroredWarehouse) | Microsoft Learn)
So right now, it's a continuous replication. I also can't see anything on the roadmap What's new and planned in Microsoft Fabric - Microsoft Fabric | Microsoft Learn
IMHO I doubt being able to truncate tables when a table is enabled for cdc is ever going to be supported as this is the case in SQL Server too, truncate is a minimally logged transaction which cdc cannot handle.
Only thing would be to DELETE but that would be logged and have (probably) significant overhead.