skip to Main Content

Improvements to SQL Managed Instance Database Migrations

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.

Post Terms: Azure SQL Managed Instance | Cloud Migration | SQL Managed Instance

About the Author

Marketing Manager, Leah Monterroso, has been writing blogs and articles for the last six years. Since working with Ballard Chalmers, she has immersed herself in Microsoft tech news and bringing value to clients and the wider community through content.

You can find Leah online at:

Back To Top
Contact us for a chat