There have been some recent improvements to SQL managed instance database migrations. Let’s take a look at some key areas.
Resumable Restore
In case of impactful system updates, resumable restore enables the resume or restart of backups in Azure SQL managed instance. This means that any in-progress backup in the General Purpose service tier will be suspended and then automatically resumed following the update. On Business Critical instances the backups will be automatically restarted rather than resumed.
Limitations Removed
The limitation to hold off impactful system updates for 36 hours once a migration had started from SQL Server to managed instance has now been removed. Instead, you can plan system updates using the managed instance maintenance window.
Additionally, the upper limit has been increased to 30 days for a continuous single Log Replay Service (LRS) migration job.
