Recently one of our customers ran Bulk insert into one of their databases which was in merge replication and later on found that Merge replication has stopped working. 1. When data is loaded into tables using the bcp Utility or the BULK INSERT command, by default, the merge replication triggers that maintain tracking data…
Hi All, In my today’s post I will be explaining a very basic stuff which we are expected to know but sometimes we may miss out on it and can lead to adverse consequences. My Field experience tells me most customer tend to forget it and hence I thought I would pen it down in…
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 which one of Customers encountered recently. Recently One of Customers had upgraded to SQL 2008 with…
We 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 start with the following error Error messages: The process could not execute ‘sp_MSpub_adjust_identity’ on…
We 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: ====== When we check the Publication properties, we find that the options for subscription expiration are…