Backup SQL Database to Azure Storage container (SAS & Access Key)

Backup SQL Database to Azure Storage container.

Video Content:
00:00 Intro
00:35 Backup SQL Database with Shared Access Signature
04:25 Backup SQL Database with Access Key

SAS: Block Blob has a 200 GB Limit
Access Keys: Page Blob has a 1 TB Limit.

For Backing up huge DB, please refer the below doc.
Backing up a VLDB to Azure Blob Storage
https://docs.microsoft.com/en-us/arch...

/* Create Credentials - Shared Acess Signature*/
CREATE CREDENTIAL [https://techknowledge.blob.core.windo...]
WITH IDENTITY='SHARED ACCESS SIGNATURE',SECRET = 'sv=2020-08-04&ss=bfqt&srt=co&sp=rwdlacupitfx&se=2022-02-07T20:52:40Z&st=2022-01-31T12:52:40Z&spr=https&sig=RS2MwuAxYTtxZhda3nYAdNYq1ruLuZ93AsCR7hHB6W8%3D'
GO

/* Create Credentials - Access Key*/
create credential access_key
with identity = 'techknowledge',
Secret = '8A4NJGJXe1QldDXjL4XkT8nwqdN+toLKiv2pwcQmNzd6Mdu474+uYl3Zb4VTBPDvf26qRGPjxzk7sFqrsFneNQ=='


/*Backup Database with Access Key*/
backup database tushardb
To URL = 'https://techknowledge.blob.core.windo...
with credential = 'access_key'