Forum Discussion
Advocate IISchedule Fabric DB Mirroring
Hello,
is there currently the possibilty to activate/deactivate the DB Mirroring via a schedule?
I can not truncate tables in the Azure SQL DB that are being mirrored as long as mirroring is active. However for some tables truncating is necessary for daily data transfer to the Azure DB.
If not pssible at the moment, is this feature on the roadmap?
Thanks!
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.
3 Replies
chris__1@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.