how to Terminate the replication relationship in Azure SQL DB

Vijay Kumar 2,031 Reputation points
2022-05-06T22:55:59.92+00:00

Hi,

I have initiated replication in one of our Azure SQL DB Primary (WestUS) Secondary on (East US).
Due to some reason, I canceled, but still showing in progress. So, other way to cancel.
199851-image.png

Azure SQL Database
0 comments No comments
{count} vote

Accepted answer
  1. Alberto Morillo 33,426 Reputation points MVP
    2022-05-07T02:51:03.957+00:00

    It is completed. Please see on the secondary region you may see what was the replica database, now a standalone database.


2 additional answers

Sort by: Most helpful
  1. Alberto Morillo 33,426 Reputation points MVP
    2022-05-07T00:21:24.487+00:00

    Please verify the status of the operation by using the following query:

    SELECT * FROM sys.dm_ operation_status  ORDER BY start_time DESC;
    

    If the operation does not seem to progress for hours, try to add another region for replication, and that may solve the issue.


  2. Alberto Morillo 33,426 Reputation points MVP
    2022-05-08T18:36:31.17+00:00

    Vijay, have you ever fixed something by trying many things and at the end you don't know what fixed the issue of all the things you tried? That is what happened to me when I faced the scenario you described. Did you tried to add another region on the replication? That is one of the things I remember I tried.

    0 comments No comments