It has been really long time since I have updated this blog as my Job involves a lot of travel however I try my best to update it frequently. In this blog I am going to discuss a issue … Continue reading
Category Archives: Replication
Log Reader Agent Fails when the Sql server instance is failed over to Node 2
TweetWe have observed a number of case where we use sql server replication on a clustered instance of sql server and when we try to failover from Node 1 to Node 2 the Log Reader agent may fail to … Continue reading
The subscription fails to Sync with the Publisher and marked inactive even though the settings have been configured to “never expire”
TweetWe get the below error message when distribution agent tries to sync, Error: 14151, Severity: 18, State: 1. The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated. CAUSE: ====== … Continue reading