May 8, 2012 at 1:29 am
Hi,
Anyone please help me
Replication are not working between two nodes in a cluster. i found that Subscriptions are marked as inactive due which one of my job is getting failed and writing error message in Event log.
ServerName\Jobname failed. One or more subscriptions have been marked inactive. Drop and re-create all subscriptions for this node that are failing with this error.
May 9, 2012 at 6:17 am
Are you looking for confirmation that the error is telling you what you need to do?
It is. Once a subscription is marked inactive it needs a new snapshot, etc... to get started again.
I hope this helps.
May 9, 2012 at 6:42 am
You may also look at the length of time you have set for subscriptions to expire. Increasing the amount of time for expiratin will not necessarily fix whatever caused your replication to stop to the subscriber, but it will allow you to either restart the replication to a subscriber or reinitialize a subscriber rather than rebuild it.
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply