Getting error in Transactional replication-The subscription does not exist

Lokesh Gonam 21 Reputation points
2022-08-15T12:36:26.287+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,653 questions
0 comments No comments
{count} votes

Accepted answer
  1. Tom Phillips 17,716 Reputation points
    2022-08-15T12:44:49.207+00:00

    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.


0 additional answers

Sort by: Most helpful