We have been saving the backups of one of our production servers (which is actually an Always On availability group)
this is how I am doing my backups and saving to 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 what I see when attempting to connect to Azure:
what would be my storage account?
I have a job that I have scheduled to send me an email about all the backups on a server. The script that collect information about the backups and send the email is here.
The email tells me where the backup is.
for example:
here is a picture for illustration purposes:
How can I have access to the backup files?
Where are these azure permissions managed?
EDIT:
The answer by David Browne got me there, thank you David.
I am just adding here a set of steps that took me to my backups (after successfully connecting to azure).
01 – Click on Blob
02 – select one of the containers
03 – the files will be there – ready for dowloading
This article is also very interesting:
First look: back up files and folders in Resource Manager deployment
Best Answer
MYCOMPANYbackups
http://portal.azure.com or AzCopy or PowerShell or Azure Storage Explorer
Permissions for accessing the blobs is controlled by the storage account keys, or Shared Access Signatures. See Azure Storage Security