0

I have some SQL server backup files on my on-premise server on the D:\AzureTesting* folder and I want to copy those .bak files from there to my Azure Blob Storage Account using Azure Data Factory? Is it feasible if so, please let me know how to proceed with? I have searched a lot on the web, but I am not getting an appropriate method for this. I tried to load using Copy activity taking File System Linked Service as my source it is showing me only the below file formats to choose from. See the Image Link for the file formats Can anyone suggest which file format should I select for accepting the. bak files from my on-premise to Azure Blob storage An answer or any kind of solution is highly appreciated.

Thanks in advance

Neha Kumari
  • 1
  • 3

1 Answers1

1

It is possible to copy it via copy activity. For the on prem server, you would have to install an integration run time and create a linked server of type: file system and the destination would be azure blob storage.

enter image description here

Nandan
  • 3,939
  • 2
  • 8
  • 21
  • Thanks @Nandan for your quick response ,I will try as per said. Hope it will fulfill my requirement. – Neha Kumari Feb 23 '21 at 06:22
  • Hey @NehaKumari, you can also refer the below link for detailed steps: https://www.mssqltips.com/sqlservertip/5928/transfer-onpremises-files-to-azure-blob-storage/ of setting IR and creating copy activity. Please mark it as answer in case if it helped as it may benefit other community members – Nandan Feb 23 '21 at 06:30
  • Hey @Nandan while choosing File System as Linked Service,it is showing me only these file formats (Avro format, Binary format,Delimited text format,JSON format,ORC format,Parquet format) to choose from . Can you suggest which file format should I select for accepting .bak files – Neha Kumari Feb 23 '21 at 13:20
  • Hey @nehakumari, you use binary format across source and destination to copy a file as is – Nandan Feb 23 '21 at 13:24
  • Hey @Nandan ,Are you sure because I have tried using the binary file format as source and sink but it gave me the following error: Failure happened on 'Sink' side. ErrorCode=AdlsGen2OperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ADLS Gen2 operation failed for: Operation returned an invalid status code 'Forbidden'. Account: 'medinsightsandbox'. FileSystem: 'uaw'. Path: 'dm_test/KumarP/Bak_File_Storage/TestFile.bak'. ErrorCode: 'AuthorizationFailure'. Message: 'This request is not authorized to perform this operation.'. . – Neha Kumari Feb 23 '21 at 13:56
  • Message: 'This request is not authorized to perform this operation.'. RequestId: '468f2a81-f01f-0039-55ba-098ac1000000'. TimeStamp: 'Tue, 23 Feb 2021 08:05:55 GMT'..,Source=Microsoft.DataTransfer.ClientLibrary,''Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Operation returned an invalid status code 'Forbidden',Source=,''Type=Microsoft.Azure.Storage.Data.Models.ErrorSchemaException,Message=Operation returned an invalid status code 'Forbidden',Source=Microsoft.DataTransfer.ClientLibrary,' – Neha Kumari Feb 23 '21 at 13:56
  • Hey @NehaKumari, Can you please test whether your file systme linked server connection was successful? Based on the error, it seems that the account doenst have access on that path in the VM – Nandan Feb 25 '21 at 13:13