Blog Post

Azure SQL Blog
3 MIN READ

Cross-instance point-in-time restore in Azure SQL Database Managed Instance

JovanPop's avatar
JovanPop
Icon for Microsoft rankMicrosoft
Mar 24, 2019
First published on MSDN on Jun 07, 2018 Azure SQL Managed Instance is a fully managed SQL Server instance hosted in Microsoft Azure cloud. Besides built-in management operations...
Updated Nov 09, 2020
Version 5.0
azure sql
roe-dk's avatar
roe-dk
Copper Contributor
Apr 13, 2022

Can anyone explain why CLI claims it cant find the source server, when trying a restore?

 

xxx@Azure:~$ az sql server list --output table
Name           ResourceGroup    Location    AdministratorLogin
-------------  ---------------  ----------  --------------------
<sourceserver> <sourceRG>       eastus2     xxx
<destserver>   <destRG>         eastus2     Cloudxxxxxxx
xxx@Azure:~$ az sql midb restore --resource-group <sourceRG> --managed-instance  <sourceserver> --name <sourceDB> --dest-name <destDB> --time "2022-04-13T08:20:00" --dest-mi <destserver> --dest-resource-group <destRG>
(ResourceNotFound) The Resource 'Microsoft.Sql/managedInstances/<sourceserver>' under resource group '<sourceRG>' was not found. For more details please go to https://aka.ms/ARMResourceNotFoundFix
Code: ResourceNotFound
Message: The Resource 'Microsoft.Sql/managedInstances/<sourceserver>' under resource group '<sourceRG>' was not found. For more details please go to https://aka.ms/ARMResourceNotFoundFix
xxx@Azure:~$

This happens both when using the CLI in the portal, and from my local workstation.