Activity: Geo-restoring a database hosted on SQL Managed Instance using the Az PowerShell module

Geo-restoring allows you to recover a database to a different region. This can be used as a database recovery solution, but the recovery time depends on the database size. Geo-backups are only available when SQL Managed Instance is configured with geo-redundant backup storage.

Let's quickly go through how to perform a geo-restore using PowerShell.

This activity is similar to the previous point-in-time restore we did using the Az PowerShell module, so all the steps are not covered here. We are only covering changes in the script.

SQLMI_GeoRestore.ps1 is available in the source code and most of the code is similar to the point-in-time restore activity.

In our geo-restore PowerShell script, we are using the same Restore-AzSqlInstanceDatabase command, but instead of using the -FromPointInTimeBackup parameter, we are using the -FromGeoBackup parameter.

The following is a...