How to Mirror a Fabric SQL Database (Not Azure SQL) and Access the Mirrored Data

Hello bhavya5903 

Thank you for reaching out to the Microsoft Community Forum.

We understand that you are seeking insights on setting up mirroring for a Fabric SQL Database.Here is the detail information that might helpful for you:

1. Create the SQL Database in Microsoft Fabric:

When you create a SQL database in Microsoft Fabric, it automatically provisions the SQL database, SQL analytics endpoint, and default semantic model in your workspace. Mirroring starts automatically with all supported tables and columns mirrored upon creation, requiring no additional settings.

2. Accessing Mirrored Data:

SQL Analytics Endpoint:

• The mirrored data is stored as Delta Parquet files in OneLake. The SQL analytics endpoint points to these files, allowing you to query the mirrored data using familiar T-SQL commands. The data accessed via the SQL analytics endpoint is read-only, protecting the operational data source from accidental writes or deletes.
  
  

Direct Access from OneLake:

• The mirrored data in OneLake can be accessed directly as Parquet files, enabling downstream scenarios like data engineering, data science, and more.

3. Best Practices and Potential Issues:

Data Consistency:

• Regularly monitor the mirroring process to ensure data consistency between the primary and mirrored databases, and promptly resolve any discrepancies.
  
  

Performance Monitoring:

• Continuously monitor the performance of both the primary and mirrored databases to ensure the mirroring process does not adversely affect the primary database's performance.
  

Security and Permissions:

• Carefully manage permissions to ensure only authorized users have access to the mirrored data, and follow best practices for securing your data in OneLake and the SQL analytics endpoint.

For more details, you can review Microsoft’s official document:

Overview of Mirroring for SQL database (preview) - Microsoft Fabric | Microsoft Learn

Limitations of Mirroring for SQL database (preview) - Microsoft Fabric | Microsoft Learn
 

If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.

Thank you!