Forum Discussion
Replicate Azure SQL database with a lag
Hello,
I am new to Azure SQL database. I am being asked by my manager to replicate our Azure SQL databases to an Azure SQL VM with a lag of 3 hours.
Does anyone know what solutions are available?
Thank you.
1 Reply
Azure SQL Database does not have a built-in option to replicate with a time lag, but you can achieve it by setting up transactional replication, log shipping, or custom ETL with Azure Data Factory to copy data to an Azure SQL VM on a scheduled delay (like every 3 hours). Log shipping is the most common method for creating a delayed secondary copy since you can control how often logs are restored.
