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
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
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..