Blog Post

Azure SQL Blog
3 MIN READ

Native database backup in Azure SQL Managed Instance

JovanPop's avatar
JovanPop
Icon for Microsoft rankMicrosoft
Mar 24, 2019
First published on MSDN on Oct 16, 2017 Azure SQL Managed Instance is a new fully managed PaaS offering in Azure cloud that will be publicly available in the near future. It will expose entire SQ...
Updated Nov 09, 2020
Version 6.0
azure sql
RoshnaNazir's avatar
RoshnaNazir
Icon for Microsoft rankMicrosoft
Apr 22, 2021

Just to add, restore is fairly simple.

You need to create public blob storage credential protected with SAS on master database just like above.

Run RESTORE FILELISTONLY statement and check if Managed Instance returns a list of the files in the backup.

And then you can finally restore the database using sample command like below:

 

RESTORE DATABASE tpcc2502

FROM URL = 'https://myacc.blob.core.windows.net/testcontainer/tpcc2501-4-1.bak',
URL = 'https://myacc.blob.core.windows.net/testcontainer/tpcc2501-4-2.bak',
URL = 'https://myacc.blob.core.windows.net/testcontainer/tpcc2501-4-3.bak',
URL = 'https://myacc.blob.core.windows.net/testcontainer/tpcc2501-4-4.bak'

 

Also regarding restoring on-premises, here is the blog - Lesson Learned #146: Restoring a backup from Azure SQL Managed Instance to OnPremises - Microsoft Tech Community