If database replication has been disconnected for too long, the subscription may become inactive. The error message may read: “The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated. The step failed.”
To fix the problem, you can either delete the subscription and recreate, or reactivate the subscription. Obviously it is easier to reactivate the subscription. Here’s how (run this script on the subscriber against the master database):
-- this script will reinitiate inactive subscriptions after they have expired.
-- This happens if the server was turned off for a long period of time (more than 72 hours)
select status,* from distribution..MSsubscriptions
update distribution..MSsubscriptions set status=2
After running the update statement, refresh the jobs and make sure the status on the REPL-Distribution job reads Executing: 2 (Run agent).
