Hello everyone,
When I create a corresponding mirrored database for Azure SQL Database using the API (as referenced in the article "Items - Create Mirrored Database"), the mirrored database status is shown as running, and I can correctly see the tables to be mirrored. However, the status remains "running," and no data synchronization occurs successfully.As below shows.
And when I switch to configuring the mirrored database for the same database using the UI, I can quickly observe that the data has been synchronized.
The above two scenarios were tested separately without simultaneously performing mirror operations on a database.
What is the reason behind this? How can Isolve it?
Hi,
Could you please post the entire json payload? Ensure you have the correct fabric permission.
if nothing works create support ticket.
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Hi,
This is the code I used to create a mirror database using the API. I verified the status of the database and table, and it is valid
