Take Control of your Azure SQL Managed Instance Migration using the Log Replay Service
summary
Log Replay Service migrates SQL Server to Azure SQL Managed Instance by restoring backups from Azure Blob Storage using AzCopy, running LRS in continuous or autocomplete modes, and controlling progress with start/get/complete commands via PowerShell background jobs. Applicable to SQL Server 2012+ when DMS or Managed Instance Link are unsuitable; used here for ~15 TB across ~40 databases to reach under one hour downtime versus ~36 hours for native backup/restore. Use compressed, striped full/diff/log backups, full recovery model, and watch for 30-day limit and broken LSN chains.
AI-written summary · about
chapters (8)
- 0:00Introduction and speaker intro
- 1:06What is Log Replay Service
- 2:31Migration options comparison
- 4:40Customer scenario for LRS
- 6:04How Log Replay Service works
- 8:35Taking control with PowerShell
- 15:41Final thoughts and best practices
- 18:47Wrap-up and Q&A
related talks
01h 02mLearn Live: Migrate SQL workloads to Azure Managed Instances
50mManaged Instance Link - Seamless migration to Azure
44mSQL Managed Instance: Fully managed SQL Server in Azure- 50mManaged Instance Link - Seamless migration to Azure
23mReturn ticket from SQL Managed Instance to SQL Server – One-Click Reverse Migration and DR
39mModernize your applications on Azure SQL Managed Instance Q&A- 23mReturn ticket from SQL Managed Instance to SQL Server – One-Click Reverse Migration and DR
52mAzure Sql DB Managed instance, a different sql server?