Replication stopped with this error "Replication-Replication Distribution Subsystem: agent SPM-MTRAC-mTrac_Test-pub_bi_directional_mT-PTE-MTRAC-3 failed. The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated."
1st Step) Browse to Distribution DB under System Database (ONLY available at Subscriber DB)
2nd Step) Run query to check the status
SELECT * FROM distribution..MSsubscriptions WHERE status = 0
3rd Step) Run distinct query to ensure we are updating the right one
SELECT DISTINCT publisher_db, publication_id, subscriber_id, subscriber_db FROM distribution..MSsubscriptions WHERE status = 0
4th Step) Update the inactive status back to active
UPDATE distribution..MSsubscriptions SET status=2 WHERE status = 0