Forum Discussion
OneLake Backup
'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
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.
- Anonymous2 years agoNot applicable
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_342 years agoFrequent Visitor
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 !
- Anonymous2 years agoNot applicable
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.