question

ElaineJacobson-3711 avatar image
0 Votes"
ElaineJacobson-3711 asked HimanshuSinha-MSFT commented

Restoring .bak file from Data Lake using Data Factory

I need to restore .bak file from vendor that is stored in our Azure Data Lake using Azure Data Factory. I have read the documentation and it sounds like a REST API could do it. Does anyone have experience using Data Factory to do this? Is it possible or is a function a better way? Or Logic Apps? Thank you.

azure-data-factory
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

HimanshuSinha-MSFT avatar image
1 Vote"
HimanshuSinha-MSFT answered HimanshuSinha-MSFT commented

Hello @ElaineJacobson-3711 ,
Thanks for the ask and using the Microsoft Q&A platform .
Just wanted to understand abit more on this . Can you not use a stored proc activity and run the restore command inside that ?
Something like this : https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/restore-sample-database-quickstart#restore-from-a-backup-file


Please do let me know how it goes .
Thanks
Himanshu

· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@HimanshuSinha-MSFT ,
Thank you for your help with my question. I'm going to try your suggestion and will let you know once I have it working.

Thanks again,
Elaine

0 Votes 0 ·

Hello @ElaineJacobson-3711 ,
Thanks for the update .
Thanks
Himanshu
Please do consider clicking on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members

1 Vote 1 ·

@HimanshuSinha-MSFT , I think I did the "Up-vote" but would like you to confirm, since I am new to the MS Q&A forum. I did find the "Accept Answer" and did select it, although I haven't completely finished the experiment of trying this stored procedure approach.

Thank you,
Elaine

0 Votes 0 ·
Show more comments