5

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? enter image description here

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: enter image description here

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

enter image description here

02 - select one of the containers

enter image description here

03 - the files will be there - ready for dowloading

enter image description here

This article is also very interesting:

First look: back up files and folders in Resource Manager deployment

  • Do you have access to your azure portal? Username and pw? Looking at your backup code it appers MYCOMPANYbackups is your storage account name. You will need to grab the key or ask someone who has access. – SqlWorldWide Jul 6 '17 at 17:27
8

what would be my storage account?

MYCOMPANYbackups

How can I have access to the backup files?

http://portal.azure.com or AzCopy or PowerShell or Azure Storage Explorer

Where are these azure permissions managed?

Permissions for accessing the blobs is controlled by the storage account keys, or Shared Access Signatures. See Azure Storage Security

  • awesome explanation with respective link. For +1 – Md Haidar Ali Khan Nov 24 '17 at 13:58

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.