Moving Database with Anonymous Merge to NEW Machine -- sql server replication

Aubrey
8/18/2005 3:36:02 PM

How do you Migrate Merge Agent Subscribers? or do we have to Orphan all
obsolete, defunct Replicas?

OK; thanks for your help. We got our Database Published, and 30+ Anonymous
Subscribers have been happily doing bidirectional Internet updates for over a
month, with an Access Runtime Project.

Now the Client wants to Upgrade the Server to Dual Opteron SATA RAID 1. It
looks like a Clean Install is the only (or at least the best) way to setup
the SBS2K3 Premium box. We have no trouble Detaching, Copying and Attaching
an SQL Database, but wonder what to do about the Anonymous Subscribers
--

Hilary Cotter
8/18/2005 8:56:38 PM

I think the best way to handle this is to run the agents one final time.
Drop the subscriptions. Make sure the subscribers are in read only mode.
Restore the publication database and rerun your publication script. Then
make your subscribers read/write, but make sure no users use them. Then do
no sync subscriptions.

--
Hilary Cotter
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]

sql server replication : Moving Database with Anonymous Merge to NEW Machine