Azure Database Migration Services (LRS), target node restart

Carl Anderton 0 Reputation points
2024-02-07T11:56:06.9933333+00:00

Hopefully a quick one, We're using Azure DMS to migrate from 1 SQL server to another - both are SQL Server on Virtual Machines. LRS is setup and running using Azure Blob storage - Full backups nightly, 5 minute Tlog backups on the source server. We have a need to restart the target server during this migration. Will this break the LRS process or will the migration continue once the target is back online (~2-3 mins down)? Kind regards, Carl

Azure Database Migration service
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,214 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Oury Ba-MSFT 17,631 Reputation points Microsoft Employee
    2024-02-14T17:25:04.56+00:00

    @Carl Anderton
    LRS is equivalent to SQL log shipping and should not be impacted by restart of target. However, it would be better to ensure that no active restore is in progress before doing the restart. For more information, refer: Overview of Log Replay Service - Azure SQL Managed Instance | Microsoft Learn Regards, Oury

    0 comments