Blog Post

Azure SQL Blog
4 MIN READ

Restore dropped database on Azure SQL Managed Instance

JovanPop's avatar
JovanPop
Icon for Microsoft rankMicrosoft
Mar 24, 2019
First published on MSDN on Jan 21, 2019. Note: This version of article is adjusted for the latest Az Powershell module Azure SQL Database - Managed Instance is fully-managed PaaS service that pro...
Updated Nov 09, 2020
Version 9.0
azure sql
azure sql managed instance
qitjose's avatar
qitjose
Copper Contributor
Apr 17, 2019

Hello JovanPop, 

 

Thanks for the script. I tried and it ran for about an hour before returning the following error:

 

New-AzResource : InternalServerError : An unexpected error occured while processing the request. Tracking ID:
'857ea045-6dde-41ce-a6a0-59e7c34763f8'
At line:1 char:1
+ New-AzResource -ResourceId "subscriptions/$subscriptionId/resourceGro ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : CloseError: (:) [New-AzResource], ErrorResponseMessageException
    + FullyQualifiedErrorId : Microsoft.Azure.Commands.ResourceManager.Cmdlets.Implementation.NewAzureResourceCmdlet

At the end the database was not restored, is there any other way to restore a dropped MI database?

 

Thanks,

Jose