Restore SQL MI Backup on SQL Server 2022



Restore SQL MI Backup on SQL Server 2022

Restore SQL MI Backup on SQL Server 2022

Walk through the tutorial on how to decrypt a database in Azure SQL Managed Instance, back it up to Azure Blob Storage, and restore that backup on a SQL Server 2022.
Learn from Bradley Ball from @Tales-from-the-Field on how-to restore a database from Azure SQL Managed Instance on SQL Server 2022.

Chapters: 
00:00 Introduction
00:28 Getting our SAS Token
01:31 Creating a database Credential
02:07 Decrypting a Database
04:51 Backing Up the SQL MI Database to Azure Blob Storage
05:00 Transition to SQL Server 2022 Instance & Restore from Script
05:38 Restore SQL MI DB Backup on SQL Server 2022 using SQL Server Management Studio (SSMS)

Recommended content:
Quickstart: SQL backup and restore to Azure Blob Storage: https://learn.microsoft.com/en-us/sql/relational-databases/tutorial-sql-server-backup-and-restore-to-azure-blob-storage-service?view=sql-server-ver16&tabs=SSMS
How to take secure, on-demand backups on SQL Managed Instance: https://techcommunity.microsoft.com/t5/azure-sql-blog/how-to-take-secure-on-demand-backups-on-sql-managed-instance/ba-p/3638369
What is Azure SQL Managed Instance?: https://learn.microsoft.com/azure/azure-sql/managed-instance/sql-managed-instance-paas-overview
What’s new in Azure SQL Managed Instance?: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/doc-changes-updates-release-notes-whats-new
How to do more with less in Azure SQL Managed Instance?: https://techcommunity.microsoft.com/t5/azure-sql-blog/quick-tips-how-to-do-more-with-less-in-azure-sql-managed/ba-p/3733435
2022 – a year of unparalleled innovation in Azure SQL Managed Instance: https://techcommunity.microsoft.com/t5/azure-sql-blog/2022-a-year-of-unparalleled-innovation-in-azure-sql-managed/ba-p/3676757