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

thyagaraj b m 81 Reputation points
2023-01-19T14:51:32.64+00:00

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. 

Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
1,406 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Ramya Harinarthini_MSFT 2,336 Reputation points Microsoft Employee
    2023-01-19T17:31:34.8433333+00:00

    @thyagaraj 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.

    User's image

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

    User's image

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

    Hope it helps!!!


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

    No comments