sql server replication: nosync w/ merge still chokes on meta data updates -- sql server replication

nosync w/ merge still chokes on meta data updates

Chris
5/6/2006 6:45:01 PM

sql server replication:
SQL2000

20 tables in merge, 6 million records total in all. Let snapshot push data
to new subscriber, snapshot and push of data to subscr was relatively quick
(maybe 2 hours total) however metadata updates were taking 30+ hours. This
was scrubbed.

Plan B, restore pub database on subscr, meta data updates appear to take
just as long.

How to get my subscriber up & running quick?

Thanks,
Chris

RE: nosync w/ merge still chokes on meta data updates

Chris
5/8/2006 10:48:02 AM

Wow - 3 bloody days & my subscriber is now online... I certainly hope
strides have been made w/ sql2005 merge repl & large tables.

[quoted text, click to view]

Re: nosync w/ merge still chokes on meta data updates

Michael Hotek
5/11/2006 10:20:02 AM

Yes, it has. When doing this with 2000, the first step you want to do is to
purge as much metadata as you can such that you minimize the amount of time
that the metadata reconcilation process takes. This is significantly less
in 2005, but you have a manual step to do this in 2000.

I've had some deployments with 2000 that have taken over a week to finally
choke down all of the metadata. (Not a very nice situation to be in.)

--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.