Forum Discussion
Restore old database in Microsoft fabric
I want to restore some old .BAK backup files in Microsoft Fabric Data warehouse. There are no restore task in there so having some problem how i can achieve this. Has anyone done this before?
Hi mandania there is no concept of .bak files for Fabric Warehouses. You'll need to use the Restore functionality
Restore in-place of a warehouse from a restore point - Microsoft Fabric | Microsoft Learn
2 Replies
Hi mandania there is no concept of .bak files for Fabric Warehouses. You'll need to use the Restore functionality
Restore in-place of a warehouse from a restore point - Microsoft Fabric | Microsoft Learn
I am not sure the accepted solution is actually a solution to the problem.
The problem is "how do you restore a SQL backup into a Data Lake?"
The answer is "you can't - or at least not directly".
The only way to do it would be to restore the bak file into a SQL Server Instance and then set up a job to copy the data into the data lake.
The Fabric restore functionality is only for Data lake data so of no use whatsoever in relation to bak files.
