locked
BackUp from SQL to Azure Storage Page Blob or Block Blobs RRS feed

  • Question

  • HI,

    I was reading one of  the Article that We can Take Backups to Block Blobs.

    If we take the SQL Statement as below and the Container type as private.

    DATABASE AdventureWorks2014  
       TO URL = 'https://<mystorageaccountname>.blob.core.windows.net/<mystorageaccountcontainername>/AdventureWorks2014_onprem.bak'

    It will store as Type Page Blob?But how can we store it like Block Blob?

    Can you Please tell me how to do that?

    I as seeing Block blobs are of Heavy Size and Page Blobs are off low Size? What is the Major difference between these Two types?

    Thanks,

    Sujith.


    Sujith

    • Moved by vikranth s Monday, February 20, 2017 8:05 PM More related to SQL Backup
    Monday, February 20, 2017 8:58 AM

Answers