Forum Discussion
Issue with backup of source when we do Mirroring Azure SQL database in Fabric
Hello we recently implemented "Mirrored Azure SQL Database" in fabric for our analyst's group so that they can analyze and build models on raw data. Everything works great on fabric side where we can access data for analysis and its real time. Thumbs up for that.
BUT at the source Azure Db when the responsible team tried to run .bacpac it failed and they had to REVOKE SELECT, ALTER ANY EXTERNAL MIRROR TO [ACCT_NAME] GO.
Is there any setting that we need to work on or any articles or setups that you suggest. Please let me know. Really appreciate your help. We tried to look for articles but couldn't much on this. Thank you for all your work and support. Appreciate your help.
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.
4 Replies
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.Thank you will try out this solution provide by you with our product team and will let you know if it works.
Appreciate your response.
Hi sruthiramana,
Thank you for reaching out in Microsoft Community Forum.
We hope your issue has been resolved. If yes,please mark it as "Accept as Solution" and give it a 'Kudos' if it was helpful. This will 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.
