Perry Whittle (11/6/2008)

---

what FSMO roles does the 1st DC hold? I'm guessing its the PDC emulator, with this server down things like password changes and failed authentication checks are unavailable.

Why...

Glad that it's working. Interestingly, BOL says that the "none" option is deprecated and MS wants you to use "replication support only" instead. The same warning is in BOL for...

Is each set of tables in a separate publication, or are you reusing the publication and just swapping out which tables are included in it?

My next suggestion exactly what you've done - manually bcp the snapshot file in, but you shouldn't have to zap anything in MSrepl_commands. I've written a blog post about how...

Ah, now I see that in the script you provided. Serves me right for trying to finish my response before I left for the day. :doze:

Just so I am clear,...

I believe that is correct. You might also want to tinker with the setting for BcpBatchSize to see if it helps. The default is 1,000 rows per transaction at the...

Not to get off topic, but how big are these tables? If they're relatively small would it make sense to change the properties of each article to NOT replicate delete...

I would keep it simple - one server as publisher, the other two as subscribers. Run the merge agents every minute, or even continuously, to keep latency at a minimum....

I suppose you could set up one server as a publisher and the other two as subscribers, then enforce the ranges that each subscriber is allowed to update with triggers...

You can create a new distribution agent profile and change the timeout value. In Replication Monitor navigate to your publication so that you can see your subscriptions in the "All...

You appear to be missing some key details here. Please provide more information about what your problem is so we can help.

Can you provide more details as to exactly what the steps are when you remove the table from the publication and add it back in?

Looking back, I'm not sure why this topic is titled "Columns not propogating" when the original poster said it was rows that were missing from the subscriber...but in any case,...

If I understand what you're saying correctly, your subscriber doesn't have rows that exist on your publisher. It sounds like you might have a filter in place which is limited...

Assuming your subscriber is part of an AD domain...As long as the subscriber's name in AD remains the same you can do this. I would stop the distribution agent first,...