Move databases on an Always On to new Always On structure without interruption

yunus emre ISIK 171 Reputation points

Hi, I have a software connected to databases on "Always On 1" as showed below. I want to move or copy databases on "Always On 1" to "Always On 2" without any software interruption. Databases have high transaction rates like banking systems so it is not wanted an interruption. Software must continue to work without any interruption. Which solution do you suggest me? User's image

Azure SQL Database
0 comments No comments
{count} votes

Accepted answer
  1. HariHaran Ramalingam 151 Reputation points

    Hi - if you are using SQL Server 2016 and above then you use DAG to do this work

    Read the below link for more info on how to set it up

0 additional answers

Sort by: Most helpful