I use Azure to store backups, the backups are saved in Azure.
sqlcmd -E -S $(ESCAPE_SQUOTE(SRVR)) -d master -Q "EXECUTE dbo.DatabaseBackup @AvailabilityGroups = 'SQLAG', @URL = 'https://MYCOMPANYbackups.blob.core.windows.net/SQLMAINSERVER-datafiles-full', @Credential = 'SQLAzureCredential', @BackupType = 'FULL', @Compress = 'Y', @Verify = 'Y', @LogToTable = 'Y'" -b
This is working fine.
There are some points I would like\need to improve though. When I need to restore a backup from Azure the backups are stored in the order they have been saved, and generally I need the most recent backup.
For example the picture below (apologies I have used this thick green to hide sensitive information like server, accounts and database names, it got really ugly but just to have an idea):
As I often need the latest backup of an specific database(s) is there a way to order how the files are stored in azure so that the first one available is the latest saved?
After downloading and installing
Microsoft Azure Storage Exporer
I can order the backup files as you can see on the picture below.