How to perform a Geo-Restore in your Azure SQL managed Instance(Using Azure portal)

Hello Readers!

The below blog content is on how do we perform Geo-restore of databases backed up automatically from the azure managed instances.


Geo-restore only means restoring the database backup taken from an instance in one region to another . It is listed as one of DR method that can be used,  in the event of a disaster causing the whole region data centers going down.

Lets get to it

Using Azure portal

Step 1:
Go to the Target instance Page in the Azure portal and click on 'New Database'



Step2: Choose the backup

In the popup we get, set a name for the New database that will be created from this restore operation.


Choose backup against  'Use Existing Data'




After the above steps, you can select the backups of databases in the drop down list below.



The backup list contains the instances in your subscription and the latest restore points created by the automated backup.

You can choose one and click on OK to initiate restore.

You can initiate many of these restore activities. It will be queued and processed according to your Vcore settings.

Thanks for visiting !.