USE Azure Managed Identity to Backup Azure SQL Managed Instance to Blob Storage, NOT SAS Tokens!!
@SQLBalls aka, Bradley Ball, walks us through how to use Azure SQL Managed Instance Managed Identity to do COPY ONLY BACKUPS to URL. There's a few reason's to use this instead of SAS tokens, and we go through them. This is a safe and secure way to backup to URL.
How to take secure, on-demand backups on SQL Managed Instance
https://techcommunity.microsoft.com/t...
Chapters
00:00 Introduction
00:51 Layout the Steps to Backup to URL
01:07 Demo - Azure Blob Storage Add Managed Identity
02:04 Demo - Create Managed Identity & Backup Database
02:40 Demo - Make Backup Statement Dynamic
04:34 Demo - Validate Backup
05:05 Demo - Create Azure SQL MI SQL Agent Backup Job
05:48 Demo - Run the Job & Validate the Backup
06:15 Why we Should USE Managed Identity vs. SAS Tokens
Watch video USE Azure Managed Identity to Backup Azure SQL Managed Instance to Blob Storage, NOT SAS Tokens!! online without registration, duration hours minute second in high quality. This video was added by user Tales From The Field 22 May 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,167 once and liked it 27 people.