OneLake Backup

[AB_34]

Hello, 

I am looking for details on how often a backup of the Fabric OneLake is taken? I remember seing an article about backups, but I cant find it anymore. I am not talking about disaster recovery or business continuity. Please send me the URL to the article if you find it, in addition find the URL to availability.

[AB_34]

Thanks for taking the time to respond. To clarify we are currently not using OneLake but are transitioning to the fabric/onelake environment, we are as a team learning what the best practices for OneLake would be. Is there any official documentation you can point me towards that discusses how we would restore data to a specific point in time ?

Thanks you !

[v-nikhilan-msft]

Hi @AB_34 
Thanks for using Fabric Community.
Apologies that I couldnt find a referral document as mentioned above. What exactly are you looking for? Can you please explain more so that I can help?

Thanks

[AB_34]

'm wondering if OneLake database is backed up. Today at my job, we backup database daily and keep a copy for a week in case database needs to be restored. In the case if there is a terrible loading issue and data gets corrupted. Is a backup available to restore data to a point of time. i.e. a couple of days back

[v-nikhilan-msft]

Hi @AB_34 
OneLake has file level soft-delete but we don't take any backups. If the data is in a warehouse, then they might be storing versions/backups on top of OneLake.

[v-nikhilan-msft]

Hi @AB_34 
We haven’t heard from you on the last response and was just checking back to see if your query got resolved. Otherwise, will respond back with the more details and we will try to help.
Thanks

[AB_34]

Thanks for taking the time to respond. To clarify we are currently not using OneLake but are transitioning to the fabric/onelake environment, we are as a team learning what the best practices for OneLake would be. Is there any official documentation you can point me towards that discusses how we would restore data to a specific point in time ?

Thanks you !

[WLY168]

I would say the Platform as a Service paradigm is shifting where Fabric is using BCDR zone replication and soft delete. ... An attempt to simplify things so that you are not supposed to care. However, point in time restore is no longer yours to determine. I tried to see if I could get Azure Backup Vault to talk to the Gen 2 Lake storage behind the scenes but could not figure out how to work the ACL's. (Backup Service would need access to the storage account abstracted behind Fabric One Lake.)

One option might be to use Azure Logic Apps and /or Automation to "copy" the contents of  

https://onelake.dfs.fabric.microsoft.com/{work space name}/{lake house name}/ 

to another separate storage account. This is workable on the assumption that you could get the right authentication and ACL's to work between the various resources.

A quick option if you are doing it for DEVELOPMENT purposes is to use Azure Storage Explorer to copy the Delta files. (It would be authenticating as yourself so should not have problems).

I don't think these options are fool proof as there is no locking during the copy and you have no guarantee that you have achieved an ATOMIC copy (there might be concurrent changes to the data.)

[v-nikhilan-msft]

Hi @AB_34 
Disaster Recovery and Data Protection for OneLake:
In the Fabric ecosystem, OneLake provides features for disaster recovery and data protection.

1) Business Continuity and Disaster Recovery (BCDR):
You can enable or disable BCDR for a specific capacity through the Capacity Admin Portal. When activated, your data is duplicated and stored in two different geographic regions, making it geo-redundant. If a disaster affects the primary region, OneLake may initiate a regional failover. After the failover, you can access your data in the secondary region via OneLake’s APIs.

2) Soft Delete for OneLake Files:
OneLake soft delete protects individual files from accidental deletion. Files are retained for a default retention period (currently 28 days, transitioning to 7 days starting May 2024). You can restore files and folders using Blob REST APIs, Azure Storage SDKs, and PowerShell.

For more information you can refer to this link: 
OneLake Disaster Recovery and Data Protection - Microsoft Fabric | Microsoft Learn

Hope this helps. Please let me know if you have any further questions.

[v-nikhilan-msft]

Hi @AB_34 
We haven’t heard from you on the last response and was just checking back to see if your query got resolved. Otherwise, will respond back with the more details and we will try to help.
Thanks