0

has anyone a sql script that allow us copy the last full backup files from azure blob container to an ftp server or simply to the machine from which we run the script (sql server machine)?

Thanks in advance

2

You can use AZCopy to move files from blob to Filesystems or eitherwise..

Below is the syntax..

AzCopy 
/Source:https://myaccount.blob.core.windows.net/mycontainer 
/Dest:C:\myfolder 
/SourceKey:key 
/Pattern:a 
/S

use the pattern option to specify name (this will work like SQL like query)

From SQLServer 2014,you can also restore from Blob directly..

Restoring From Backups Stored in Microsoft Azure

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.