If database replication has been disconnected for too long, the subscription may become inactive/Expired/Not Running Expiring Soon. 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,But this will need downtime. We can simply execute the below scripts and reactivate the subscription.
To Re-active all the subscription's :
----------------------------------------
select status,* from distribution..MSsubscriptions
update distribution..MSsubscriptions set status=2
(or)
Use Distribution
update dbo.MSsubscriptions set status=2 where status=0
After running the update statement, refresh the jobs and make sure the status on the REPL-Distribution job shows Executing.
No comments:
Post a Comment