SQL 2000.
We have multiple million + row tables in merge. Just introduced new
subscriber, metadata updates taking days (literally).

Is it safe to manually move data from publisher db, and add merge
subscription with @sync_type = 'none' ?

Thanks,

Yes, or you could back up the publisher, restore it on the subscriber, and
then do a nosync.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



[quoted text, click to view]