Back to Browse

Azure SQL Managed Instance - Database Backup and Restore using BAK file

2.0K views
Jul 30, 2024
5:26

Whether it is for creating a Dev environment, or migrating an environment from one place to another, you may find yourself needing to move a copy of an Azure SQL Managed Instance (MI) to another location, either on-prem or elsewhere in the cloud. This video is a quick guide to a basic backup and restore of an Azure SQL MI database, using a BAK file as the form of movement. Note that Azure SQL DB does not support BAK files, so this can only be restored in other Azure SQL MI or SQL Server implementations. For more detailed considerations about using BAK files, as well as working with Azure SQL MI backups and alternatives approaches to what is shown in this video, follow this link for the Microsoft documentation: https://techcommunity.microsoft.com/t5/azure-sql-blog/how-to-take-secure-on-demand-backups-on-sql-managed-instance/ba-p/3638369 https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/long-term-backup-retention-configure?view=azuresql&tabs=portal

Download

1 formats

Video Formats

360pmp411.2 MB

Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.

Azure SQL Managed Instance - Database Backup and Restore using BAK file | NatokHD