Successfully added
Azure Daily 2022
by Gordon
Resumable restore improves SQL Managed Instance database migrations experience - Microsoft Tech Community
Today we are announcing improvements that 1) Enable resumable database backup restores for Azure SQL Managed Instance in case of impactful system updates, and 2) Removal of the 36 hrs. limitation to hold off system updates once a migration from SQL Server to managed instance has started. These improvements apply to Log Replay Service (LRS), Azure SQL migration extension for Azure Data Studio, and Azure Database Migration Services (DMS).
Log Replay Service (LRS) is our implementation of the SQL Server log shipping to the cloud, and perhaps the most used feature for orchestration of migration jobs from SQL Server 2008-2019 to Azure SQL Managed Instance. LRS infrastructure powers Azure SQL migration extension for Azure Data Studio, and Azure Database Migration Services (DMS). Azure Blob Storage is used as an intermediary to store backup files from SQL Server, and LRS is used to restore these backup files on managed instance in NORECOVERY mode. Customers can add differential and log backups continuously to Azure Blob Storage, and these will be continuously restored on Managed instance. Once the last backup file has been restored, and manual or automated cutover initiated, the migration is complete.
Referenced in:
Comments