Current Database size 1.5 TB . Plz suggest us best approach to backup DB to Azure Blob store without any issues.

Question

Hi Team,

As part of data migration, the current database size is 1.5 TB. Is it possible to store the large database backup files in the container on Azure Blob Storage? If yes, Kindly help me on this ( or ) please send me if any scripts for backup large databases on On- premise SQL server to azure Blob storage. 

Answer 1

@Thyagarajulu B M Welcome to Microsoft Q&A, thank you for posting your here!!

You can Choose from various options available for data transfer from on-premises to Azure Blob storage depending on

• Data size - Size of the data intended for transfer,
• Transfer frequency - One-time or periodic data ingestion, and
• Network – Bandwidth available for data transfer in your environment.

If the size of the data is 1.5 TB assuming if the transfer frequency is once and with moderate bandwidth to High Bandwidth you can choose the available tools (Azcopy, Storage explorer, CLI, powershell, Rest API's, Data Box and Data Factory) from the below table.

Also, you can check the duration of the data transfer with respect to the Network bandwidth.

Please check the below reference link on how to transfer the data with different tools.

• Transfer data with Data Box.
• Transfer data with AzCopy.
• Transfer data with Data Box Gateway.
• Transform data with Azure Stack Edge before sending to Azure.
• Learn how to transfer data with Azure Data Factory.
• Use the REST APIs to transfer data:
  • In .NET
  • In Java

Hope it helps!!!

---

Please "Accept as Answer" if it helped so it can help others in community looking for help on similar topics.