Blog Post

Azure SQL Blog
7 MIN READ

Migrate Amazon RDS for SQL Server to Azure SQL Managed Instance – Part 2 (Native Backup & Restore)

NikoNeugebauer's avatar
NikoNeugebauer
Icon for Microsoft rankMicrosoft
May 13, 2022
In the previous post, Migrate Amazon RDS for SQL Server to Azure SQL Managed Instance - Overview (microsoft.com), we have introduced an overview of the series and summarized different migration optio...
Updated Sep 27, 2022
Version 2.0
azure sql
azure sql managed instance
AlinSelicean's avatar
AlinSelicean
Copper Contributor
Sep 27, 2022

Hi Niko

Long time fan of you articles, but this article contains misleading / wrong information. Or at least as of now (2022-09-26). NORECOVERY is not supported (or no longer) in Azure SQL Database Managed Instance:

 

Msg 41901, Level 16, State 2, Line 39
One or more of the options (norecovery) are not supported for this statement in SQL Database Managed Instance. Review the documentation for supported options.