Forum Discussion
Lakehouse - restoring data
Hi,
How to restore data in Lakehouse? Is there something similar to restore points in Warehouse? I know that I can restore deleted table but I need to restore modified data.
You may want to look into the time travel feature that lakehouses and warehouses have if backing up and restoring an entire lakehouse isn't quite what you're looking for. Time travel in Microsoft Fabric - Inviso Corporation
Lakehouses don't currently have a native "restore point"-like feature. Consequently, data recovery will have to be handled manually in regards to lakehouses. The recommended method, as outlined in the following forum links, is to just create a copy of your lakehouse and schedule a data pipeline to handle the copying.Solved: How to take backups for Lakehouse ,warehouse and p... - Microsoft Fabric Community
Lakehouse Backup - Microsoft Fabric Community
Here is some Microsoft documentation generally outlining how to accomplish this: Microsoft Fabric disaster recovery experience specific guidance - Microsoft Fabric | Microsoft Learn
3 Replies
You may want to look into the time travel feature that lakehouses and warehouses have if backing up and restoring an entire lakehouse isn't quite what you're looking for. Time travel in Microsoft Fabric - Inviso Corporation
Lakehouses don't currently have a native "restore point"-like feature. Consequently, data recovery will have to be handled manually in regards to lakehouses. The recommended method, as outlined in the following forum links, is to just create a copy of your lakehouse and schedule a data pipeline to handle the copying.Solved: How to take backups for Lakehouse ,warehouse and p... - Microsoft Fabric Community
Lakehouse Backup - Microsoft Fabric Community
Here is some Microsoft documentation generally outlining how to accomplish this: Microsoft Fabric disaster recovery experience specific guidance - Microsoft Fabric | Microsoft Learn
Hi jacek_dab,
Thank you for reaching out to the Microsoft Fabric Forum Community.
As mentioned by Witmanm, currently, Lakehouses don't support restore points like Warehouses do, and data recovery for modified records has to be handled manually.
Here's a relevant idea thread that discusses this limitation in detail:
Lakehouse Recovery or Restore Points - Microsoft Fabric Community
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.
Thank you.
From what you’ve shared, it seems that:
1. Time travel is the preferred method for restoring data.
2. Before making any changes, it’s best to manually copy the affected tables.
3. Regardless of that, I should set up a pipeline to regularly back up the Lakehouse.
4. Disaster recovery, as the name suggests, is really meant for actual disasters.
