question

chinchin avatar image
chinchin asked

Error during removal of article from Publication

Hi all, I have Server A mirroring to Server B. Server A also having Transactional Replication to Server C. When Server B become Primary, I cant remove the article (a table) from the transactional replication publication using UI. The error is as attached. Anyone faces this before? :( ![alt text][1] [1]: /storage/temp/3192-error.png
mirroringtransactional-replication
error.png (20.9 KiB)
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Magnus Ahlkvist avatar image Magnus Ahlkvist commented ·
What's the server architecture of your replication setup? Does A and B share distributor? Where's that distributor? Did you setup the agents with FailoverPartner?
0 Likes 0 ·

1 Answer

·
chinchin avatar image
chinchin answered
Hi Magnus =D Server A: Microsoft SQL Server 2008 (SP4) - 10.0.6000.29 (X64) Sep 3 2014 04:11:34 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.0 (Build 6002: Service Pack 2) (VM) Server B: Microsoft SQL Server 2008 (SP4) - 10.0.6000.29 (X64) Sep 3 2014 04:11:34 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.0 (Build 6002: Service Pack 2) (VM) Server D (Distributor, also act as Witness: Microsoft SQL Server 2008 (SP4) - 10.0.6000.29 (X64) Sep 3 2014 04:11:34 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1) (VM) Yes, Server A and B share Distributor (Server D) because during the creation of that subscription, I selected the option "Run all agents at the Distributor, ServerD (push subscription)". However I found out that when I "EXEC sp_get_distributor" at Server B, it returned nothing. Below is the Distributor property at Server D. ![alt text][1] Yes, I have setup the agents with Failover Partner, and whenever A failover to B, the transactional replication works well from B to C. [1]: /storage/temp/3198-distributor1.png Am I missing something somewhere?

distributor1.png (9.6 KiB)
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

chinchin avatar image chinchin commented ·
Hi Magnus, I have created a dummy Publication (ServerD as Distributor) at the Server B so that "EXEC sp_get_distributor" at Server B will return "SERVERD" as result. After that I removed the dummy Publication. Finally I am able to remove the article without problem. Thanks !!
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.