Based on this old thread :
If you want to use Azure Portal for restore and Backups
Perform a geo-restore operation using Azure Portal.
Log in to the Azure portal -> Browse the Azure SQL Server -> Create a SQL database -> Select a backup -> Browse the database -> Click OK
If you want to geo-restore operation using Powershell :
- Log in to the portal
- Open the CloudShell PowerShell console
- List the subscription. If your account has multiple subscriptions, then list the intended subscription where you have the database
- Set the subscription Id using Get-AzSubscription output piped to Set-AzContext.
- Get the geo-backups details into the variable $geobackups for the specified database SSISDB
- Prepare the restore by listing the target resource group name, target server and target database and
Set-AzContext -SubscriptionId ù
- In this case, the SSISDB restored to the target Azure SQL database.
$ourceGroupName= 'xxxxx' $ServerName='xxxxx' $TargetResourceGroup='xxxxx' $TargetServer='azuresqlxxxx' $TargetDatabaseName='SSISDB_Target' $GeoBackups = Get-AzSqlDatabaseGeoBackup -ResourceGroupName $resourceGroupName -ServerName $ServerName $GeoBackups | Where-Object {$_.DatabaseName -eq "SSISDB"} ($GeoBackups | Where-Object {$_.DatabaseName -eq "SSISDB"}).ResourceId Restore-AzSqlDatabase -FromGeoBackup -ResourceGroupName $TargetResourceGroup -ServerName $TargetServer -TargetDatabaseName $TargetDatabaseName -ResourceId ($GeoBackups | Where-Object {$_.DatabaseName -eq "SSISDB"}).ResourceId