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 availa...
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.