title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.topic | ms.search.form |
---|---|---|---|---|---|---|---|---|
Troubleshoot Fabric mirrored databases |
Troubleshooting scenarios, workarounds, and links for mirrored databases in Microsoft Fabric. |
WilliamDAssafMSFT |
wiassaf |
imotiwala, roblescarlos, maprycem, cynotebo |
05/09/2024 |
fabric |
troubleshooting |
Fabric Mirroring |
Scenarios, resolutions, and workarounds for Microsoft Fabric mirrored databases.
[!INCLUDE feature-preview-note]
Review the troubleshooting section of frequently asked questions for each data source:
- Troubleshoot Mirroring Azure SQL Database and FAQ about Mirroring Azure SQL Database
- Troubleshoot Mirroring Azure Cosmos DB and FAQ about Mirroring Azure Cosmos DB
- Troubleshoot Mirroring Snowflake
Review limitations documentation for each data source:
- Limitations in Microsoft Fabric mirrored databases from Azure SQL Database
- Limitations in Microsoft Fabric mirrored databases from Azure Cosmos DB
- Limitations in Microsoft Fabric mirrored databases from Snowflake
When you select Stop replication, OneLake files remain as is, but incremental replication stops. You can restart the replication at any time by selecting Start replication.
You might want to do this when resetting the state of replication, after source database changes, or as a troubleshooting tool.
This section contains general Mirroring troubleshooting steps.
Why am I getting "trial capacity" or "internal server" errors when I try to create a mirrored database"?
You must enable mirroring for your workspace or tenant. For more information, see enable mirroring. If you observe persistent errors, open a support ticket.
- Check your connection details are correct, server name, database name, username, and password.
- Check the server is not behind a firewall or private virtual network. Open the appropriate firewall ports.
Currently, views are not supported. Only replicating regular tables are supported.
- Check the monitoring status to check the status of the tables. For more information, see Monitor Fabric mirrored database replication.
- Select the Configure replication button. Check to see if the tables are present in the list of tables, or if any Alerts on each table detail are present.
- Select the Configure replication button.
- Select the Alert icon next to the table detail if any columns are not being replicated.
The Fabric warehouse does not support VARCHAR(max) it only currently supports VARCHAR(8000).
In the Monitoring page, the date shown is the last time data was successfully replicated.
Changing the source database is not supported. Create a new mirrored database.