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