Forum Discussion
Solved
Open Mirroring Stops Working
I'm excited about the promise of Open Mirroring so far it seems to be the best and cheapest (in capacity usage) solution to lift our on-prem SQL Server data to Fabric. However, I've come across a Maj...
Hi, russellprice9
Please refer to the following suggestions.
- Check for Naming Conventions and File Structures: Verify that the naming conventions and file structures are consistent with the documentation. Any deviation might cause issues with the mirroring process.
- Monitor the Replication Status: Use the monitoring tools available in Fabric to check the status of the replication. This can help identify if there are any errors or issues during the replication process. Monitoring in Fabric Data Warehouse overview - Microsoft Fabric | Microsoft Learn
- Investigate the Landing Zone Directory: Since you mentioned adding another directory under the lakehouse Files location to store the CDC LSN's, ensure that this does not interfere with the mirroring process. It might be worth testing without this additional directory to see if the issue persists.
Check the following link for troubleshooting.
Troubleshoot Fabric Mirrored Databases From Azure SQL Database - Microsoft Fabric | Microsoft Learn
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, russellprice9
Please refer to the following suggestions.
- Check for Naming Conventions and File Structures: Verify that the naming conventions and file structures are consistent with the documentation. Any deviation might cause issues with the mirroring process.
- Monitor the Replication Status: Use the monitoring tools available in Fabric to check the status of the replication. This can help identify if there are any errors or issues during the replication process. Monitoring in Fabric Data Warehouse overview - Microsoft Fabric | Microsoft Learn
- Investigate the Landing Zone Directory: Since you mentioned adding another directory under the lakehouse Files location to store the CDC LSN's, ensure that this does not interfere with the mirroring process. It might be worth testing without this additional directory to see if the issue persists.
Check the following link for troubleshooting.
Troubleshoot Fabric Mirrored Databases From Azure SQL Database - Microsoft Fabric | Microsoft Learn
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.