Share via

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

yunus emre ISIK 181 Reputation points
2023-11-14T08:09:15.45+00:00

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
Accepted answer
  1. HariHaran Ramalingam 151 Reputation points
    2023-11-14T17:24:30.64+00:00

    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

    https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/distributed-availability-groups?view=sql-server-ver16

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

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.