SQL Server 2012 Transactional Replication - twin subscriptions on same machine

Question

Server A publishes Pub1, Server B subscribes to Pub1.

Server A and Server B are both SQL Server 2012 Standard Edition, default instances.

When I use Replication Monitor to drop-in a Tracer Token, one publisher-subscriber shows-up passing the token as expected.

When I run sp_helpsubscription 'Pub1' on Server A, one subscription shows-up as expected.

When I expand Replication->Local Subscriptions in SSMS on Server B, two identical subscriptions show-up.

What's going on? Which subscription should I delete at Server B?

Hi Erik, try to execute the following query on the subscriber database (the one on server b): SELECT distinct publisher, publisher_db, publication, time, transaction_timestamp, subscription_guid FROM dbo.MSreplication_subscriptions ORDER BY 1,2,3 — Giova, Jan 25, 2016 at 10:44
@Giova, 2 rows are returned, one for each subscription. The first 3 columns are identical, the last 3 columns differ. — SethB, Jan 26, 2016 at 20:35

SethB · Accepted Answer · 2016-01-26 21:28:56Z

0

Giova's query brought into sharper focus the name of the publication; Pub 1 vs. Pub_1, for example.

The difference between the two subscriptions was the under-bar, '_', character in the name of the publication.

The subscription referencing the non-existent publication was deleted.

answered Jan 26, 2016 at 21:28

SethB

1

Add a comment |

1 Answer 1