how to Terminate the replication relationship in Azure SQL DB

Question

how to Terminate the replication relationship in Azure SQL DB

Vijay Kumar 2,061

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.

Answer accepted by question author

2 additional answers

Your answer

Answer 1

Alberto Morillo 35,401 MVP Volunteer Moderator

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

Vijay Kumar 2,061 Reputation points

2022-05-07T05:21:56.623+00:00

No it's not completed.

Still inprogress and only 59% completed.

Here is the status on the primary replica still seeding and unable to retrieve

Answer 2

Alberto Morillo 35,401 MVP Volunteer Moderator

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.

Vijay Kumar 2,061 Reputation points

2022-05-07T00:31:09.767+00:00

Here is the output:

Answer 3

Alberto Morillo 35,401 MVP Volunteer Moderator

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.

Share via

how to Terminate the replication relationship in Azure SQL DB

2 additional answers

Your answer