Best/Safe way to copy Daily SQL Backups from OnPrem to Azure Blob (to protect from Ransomware)

Question

we want to copy our daily full SQL backups to Azure blob storage (to get benefit of soft-delete & versioning) to protect from Ransomware and daily full backup size for all databases is almost 3 TB. What is the fastest and recommended way to load such data everyday from OnPrem to Azure?

Answer 1

@Prince Rastogi Firstly, apologies for the delay in responding here and any inconvenience this issue may have caused.
Welcome to Microsoft Q&A Forum, Thank you for posting your query here!

• You can use Azcopy tool or Azure Data factory (Copy data from a SQL Server database to Azure Blob storage)
• Backup On-Premise SQL Server to Azure BLOB Storage

This article provides an overview of some of the common Azure data transfer solutions. The article also links out to recommended options depending on the network bandwidth in your environment and the size of the data you intend to transfer. Choose an Azure solution for data transfer

Hope this helps!
Kindly let us know if the above helps or you need further assistance on this issue.

-------------------------------------------------------------------------------------------------------------------------------------------------------

Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.

Answer 2

Hi @Sumarigo-MSFT

I am not looking for copy only data, I am looking some type of solution that will copy 3 TB SQL Backups files (multiple backups files) from on-Prem to Azure daily.