topic Re: How to take backups for Lakehouse ,warehouse and pipelines in Fabric in Data Engineering

How to take backups for Lakehouse ,warehouse and pipelines in Fabric

Anonymous — Thu, 22 Aug 2024 14:28:11 GMT

Hi all ,
I have 2 questions

Question 1 :

I want to take backups for Lakehouse, warehouse and pipeline within Fabric. Is there any way to take that? I see for warehouse we have option called restore points but that for only drop tables, but i want entire backups. for example, if i delete warehouse/Lakehouse how to restore?

I found some articles in Microsoft fabric but those are
1) restore points in warehouse : Restore in-place of a warehouse from a restore point - Microsoft Fabric | Microsoft Learn
2) disaster recovery : Microsoft Fabric disaster recovery experience specific guidance - Microsoft Fabric | Microsoft Learn

but I need especially backups for warehouse, lakehouse and pipelines .

Question 2 :

I found one article for backup and restore environments : Back up and restore environments - Power Platform | Microsoft Learn

here it showing in Power Platform admin center, is Power Platform and Fabric admin centers are same or different?

Please anyone help me on this .

Regards ,
Shiva .

Re: How to take backups for Lakehouse ,warehouse and pipelines in Fabric

frithjof_v — Fri, 23 Aug 2024 09:49:40 GMT

Please vote for these Ideas to highlight this need:

Fabric Recycle Bin

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=90c83fe3-3461-ef11-a4e5-6045bdb54c1c

Lakehouse Recovery or Restore Points

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=36fb5834-45ac-ee11-92bd-6045bdb0416e

Lakehouse/Warehouse backups

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=978304aa-b062-ee11-a81c-6045bdbc6bc0

Fabric Synapse Datawarehouse Backup and Restore Capability

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=aa924f59-f30d-ee11-a81c-000d3ae52c8f

Question 2: They are different

Re: How to take backups for Lakehouse ,warehouse and pipelines in Fabric

Anonymous — Fri, 23 Aug 2024 02:20:16 GMT

Hi @Anonymous ,

Thanks for the reply from frithjof_v .

Question 1:

There is currently no lakehouse backup support. The best you can do is manually copy the data to another lakehouse.

If you want to backup the whole warehouse, that is also currently not supported. You may need to manually export the data or copy it to another storage location.

Pipelines do not have a direct backup feature. You can make a manual copy using the Save as option.

Question 2:

Power Platform and Fabric admin center are different.

Power Platform includes tools such as Power Apps, Power Automate and Power BI.
Microsoft Fabric is more focused on data management, analytics, and governance.

If you would like to learn more about both, please see the documentation below:

Microsoft Fabric vs. Power Platform: Choosing the Right Tool for Your Business - Microsoft Fabric (fabriconelake.com)

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

Re: How to take backups for Lakehouse ,warehouse and pipelines in Fabric

Anonymous — Fri, 23 Aug 2024 09:29:03 GMT

Thanks for the information Yang .

Regards ,
Shiva .

Re: How to take backups for Lakehouse ,warehouse and pipelines in Fabric

Anonymous — Fri, 23 Aug 2024 09:31:11 GMT

Okay

Regards

Shiva .

Re: How to take backups for Lakehouse ,warehouse and pipelines in Fabric

frithjof_v — Fri, 23 Aug 2024 09:50:00 GMT

I also created this idea:

Fabric Recycle Bin

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=90c83fe3-3461-ef11-a4e5-6045bdb54c1c