Issue with backup of source when we do Mirroring Azure SQL database in Fabric

Hi sruthiramana,

Thank you for reaching out in Microsoft Community Forum.

When using Mirrored Azure SQL Database in Microsoft Fabric, .bacpac exports may fail because the Fabric service account is granted special permissions like:

SELECT

ALTER ANY EXTERNAL MIRROR

Please follow below steps to acheive this error;

1.Revoke Fabric permissions before export:
REVOKE SELECT, ALTER ANY EXTERNAL MIRROR TO [Fabric_Service_Account];

2. Please Export the .bacpac.

3.Re-grant permissions after export:
GRANT SELECT, ALTER ANY EXTERNAL MIRROR TO [Fabric_Service_Account];

Please follow below links for your refernce;

Mirroring - Microsoft Fabric | Microsoft Learn

Please continue using Microsoft community forum.

If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.

Regards,
Pavan.

Hi sruthiramana,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, kindly "Accept  as  Solution" and give it a 'Kudos' so others can find it easily.

Thank you,
Pavan.