Azure sql as a warm standby

Joel Fleischman 1 Reputation point
2020-12-22T02:38:44.37+00:00

Is it possible to setup azure managed sql, as a warm standby for on prem sql?
It appears that log shipping isn't supported, neither restoring anything other then a full backup.

Azure SQL Database
{count} votes

1 answer

Sort by: Most helpful
  1. KalyanChanumolu-MSFT 8,351 Reputation points
    2020-12-22T06:09:13.74+00:00

    @Joel Fleischman Welcome to Microsoft Q&A forums and thank you for your interest in Azure SQL Database.

    You can set up Azure SQL database as a warm standby using transactional replication from you on-premise SQL Server.

    Please check the documentation below

    Replication to Azure SQL Database

    Step by Step walkthrough of Transactional Replication from On-Premise SQL Server to Azure SQL Database

    Please let us know if you have any further questions.

    ----------

    If an answer is helpful, please "Accept answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread.

    1 person found this answer helpful.
    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.