Getting error in Transactional replication-The subscription does not exist

Question

Getting error in Transactional replication-The subscription does not exist

LG 21

All of a sudden we got error in transactional replication stating The subscription does not exist.

and from then we started receiving the error The subscription to publication 'Report_Rep' has expired or does not exist.

Let me know how this can be troubleshooted.

Regards

Answer 1

Tom Phillips 17,611

Did the subscription ever work?

This error is almost always caused by something on the subscriber happened which removed the subscription, a restore or something.

The best thing to do is try to reinit the subscription and rerun the snapshot agent. If that doesn't work. you will need to remove the subscription and recreate it on the publisher/subscriber.

LG 21 Reputation points

2022-08-15T13:58:28.817+00:00

Thanks Tom for your response.

Yes , it was working till this morning all of a sudden the issue has started. Is there any way to find out how it got removed?

Will try to follow the steps mentioned will keep you posted about the steps which i try.

Regards.
CathyJi-MSFT 20,786 Reputation points Microsoft Vendor

2022-08-16T06:19:13.473+00:00

Hi @LG ,

Did you try the suggestion mentioned by Tom? Did your issue resolve? If it works well, please mark Tom’s reply as answer, if it is not work, please share us the progress of this issue.
LG 21 Reputation points

2022-08-16T13:31:32.347+00:00

Yes, the steps suggested has fixed the issue. Now replication is working fine.

Regards

Getting error in Transactional replication-The subscription does not exist

0 additional answers

Activity