Blog Post

Azure Database Support Blog
3 MIN READ

Restore database across servers(Azure SQL Database and Azure SQL managed instance)- Azure Automation

Sabrin_Alsahsah's avatar
Sabrin_Alsahsah
Icon for Microsoft rankMicrosoft
Aug 30, 2021
In this article, you will find the required steps and setup to restore your Azure SQL database from one Azure SQL server to another Azure SQL server. The provided method can be applied on both Azure ...
Updated Sep 21, 2022
Version 2.0
azure automation
azure sql
copy database
maintenance plan
powershell
Restore
SQL Database
sql managed instance
sql server
adam_schildmeyer's avatar
adam_schildmeyer
Brass Contributor
Dec 06, 2022

mikeholdercoretek yeah, you can't have overlapping names in Azure, so you'll have to drop/remove before restoring. Azure SQL managed instances are always backing up so you really would want to target a point in time to restore from.

Before I do my restores, I run this -

#Set Dev Context and delete all databases on managed instance defined below
Set-azContext -SubscriptionId $DevSubscription
Get-AzSqlInstanceDatabase -ResourceGroupName $targetResourceGroupName -InstanceName $targetInstanceName | Remove-AzSqlInstanceDatabase -Force

^That block will drop all databases in my lower environment. 

I then restore databases by duplicating for each restore. I couldn't find a good way to loop it in a supported way.