Restore old database in Microsoft fabric

[mandania]

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?

[johnnyo]

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.

[AndyDDC · Accepted solution]

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