none
Upload to Azure from SQL server Fails after 15 to 20 mins

    Question

  • Hi,

    I use the Azure blob storage as a backup for my sql server.

    I am uploading the bkp files to the cloud using the "Azure backup client (AzCopy)"

    the upload fails every time within 15 to 20 mins. (throwing a timeout error).

    we have a 60Mbps internet link

    any inputs would be highly appreciated.

    Tnx,

    Siby

    Sunday, February 21, 2016 9:32 AM

All replies

  • Hi,

    Have you tried running the AzCopy command again and checked if your copying process resumes?
    To resume the transfer, just run the same .\azCopy.exe command or use a script like:

    [int]$Failed = $Result[5].Split(":")[1].Trim() $Journal = "$env:LocalAppData\Microsoft\Azure\AzCopy" $i=1 while ($Failed -gt 0) {     $i++     [int]$Failed = $Result[5].Split(":")[1].Trim()     $Result = .\AzCopy.exe /Z:$Journal     $Result     $i }
    This script will continue to run the same .azCopy.exe command until "Transfer Failed" output is down to zero. azcopy tool stores 2 journal files under %\AppData%\Local\Microsoft\Azure\AzCopy like C:\Users\samb\AppData\Local\Microsoft\Azure\AzCopy folder. It looks them up upon starting to detect if this is a transfer that did not complete and resumes it.

    Regards,
    Malar.

    Monday, February 22, 2016 4:34 AM
  • Hi Malar,

    Thanks for the tip. i will try this and let you know.

    Regards,

    Siby

    Monday, February 22, 2016 6:55 AM