I’ve been stuck on a replication problem for a few weeks now and am getting rather desperate.
We’ve been using replication of our production databases successfully for a couple years now to a local server for reporting purposes, but now we’re attempting to also use it over a WAN
for disaster recovery in a remote location. Our current setup is as follows:
5 production databases on 5 separate servers
5 distributors on 5 separate servers
1 subscriber for all replicated databases
Now we’re trying to add 5 more subscribers for disaster recovery, using the original publications and distributors. All databases involved are SQL 2005 and we’re using transactional
replication with push subscriptions. So far I’ve been able to get replication working for 3 of the 5 databases, but as soon as the snapshot is delivered for a fourth, replication starts falling behind for that database only, and it never catches
up. Transactions are replicating successfully, but just not nearly fast enough.
I’ve tried replicating each of the two remaining databases separately as the fourth instance, and I’ve tried stopping replication to everything except for these databases,
and I get the same results. The remaining two databases do happen to be the biggest (2-4 GB) and the busiest (up to 400,000 dist
View Complete Post