New answers tagged transactional-replication
The first problem: Error 21488 No active subscriptions were found. The publication must have active subscriptions in order to post a tracer token. This happens when attempting to put in a tracer token without an active subscription. This error seems pretty obvious. Error 18752 Only one Log Reader Agent or log-related procedure (sp_repldone, ...
Yes, you can replicate from Enterprise edition to Standard edition. The only caveat is Peer-to-Peer Replication requires all nodes to be Enterprise Edition, and Web and Express editions are Subscriber only. Features Supported by the Editions of SQL Server - Replication
An alter procedure would not normally be replicated and so would not cause any problems. More than likely you're doing DDL operations and changing the tables and this is breaking the replication. Michael Keleher has suggested your replication may not be set up to replicate schema changes: Open the properties of the publication, go to the Subscription ...
First off, don't try to do it manually. It's harder than you think. Honest, just don't. CDC is really useful for data capture, for event handling etc. However, you really should use Replication here. I have a replicated database to over 150 warehouses and it works well. One thing I would strongly recommend is you use a VIEW for your replication filtering. ...
I believe whenever transactional replication is initialized, the Publisher snapshots the articles in the publication and pushes it across to the subscriber. The remote Distributor and pull subscriber are used for the transactions after replication has been setup and initialized.
Top 50 recent answers are included