Greetings, this is my first question posted to SSC, please have mercy! :)
We have Transactional Replication running from SQL Server 2005 to 2012 (both standard editions). The distributor sits with the subscriber on the SQL2012 machine. Since we fired it up we have been getting sporadic failures of data import SPs. By sporadic I mean cca. 1 failure in 20-30 executions. The error message is:
Due to active snapshot? - We don't use the Snapshot Agent; it is disabled.
Other schema change activity? - We are getting these failures since we started using replication and we are doing just as much schema changes at the moment as we had been doing before replication was started.
We have thousands of SPs and 99% of them don't do any DDL. Then there's sp_doSomething which is one in the 1%. It runs about 50 times a day and does something along these lines:
Triggers, check constraints are NOT replicatied. The question is then: Why are we getting this?
The parameters of the publication for your reference:
Both publisher and subscriber are on latest SP.
Any suggestion is welcome!
asked Sep 20, 2013 at 09:38 AM in Default