HiveBrain v1.2.0
Get Started
← Back to all entries
snippetsqlMinor

How to connect to microsoft azure?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
azureconnectmicrosofthow

Problem

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

Solution

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

Context

StackExchange Database Administrators Q#178180, answer score: 8

Revisions (0)

No revisions yet.