sql server replication: Hi,

I am going to reinitialize the replication at the
subscriber. Will this action lock the tables at the
subscriber and how long will it take? Any adverse impact
on the subscriber?

This would all be dependant on your replication
configuration I beleive. Plus potentially the amount of
tables and data you have. If you specified to "drop and
recreate existing tables" when the snapshot agent is run,
which is the default, it could take a while. If you
specified "leave the existing table unchanged", it should
be pretty quick. But then I wouldnt know why you would
bother to re-init.


[quoted text, click to view]