Use rs_helproute to check for route problems.
- Make sure no other databases are replicating
through the same route as the non-replicating subscription.
If other
databases are replicating through that route, then problems within
the primary Replication Server/database and replicate Replication
Server/database are more likely. It is unusual for replication
to have stopped for one database while replication continues through
the same route for other databases. Run admin stats, md on
the replicate Replication Server to see if “Messages Delivered” increases
over time.
- If no other databases are replicating through
the same route as the nonreplicating subscription, run rs_helproute at
the primary or destination Replication Server in the RSSD to determine
if there is a route problem.