Move Repliaction

Hi
I have 1 publisher that replicates well to to Server1 and doesn't replicate
well to Server2 I would like to simply move the database and the
Subscription from Server1 to Server2 (that will save me the initial phase of
the subscription of copying the database) (Push subscription)
Is that possible and how?
Thank you,
Samuel
You would have to script it out and recreate it on server 2.
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
"Samuel Shulman" <samuel.shulman@.ntlworld.com> wrote in message
news:uN$353T5GHA.4616@.TK2MSFTNGP05.phx.gbl...
> Hi
> I have 1 publisher that replicates well to to Server1 and doesn't
> replicate well to Server2 I would like to simply move the database and the
> Subscription from Server1 to Server2 (that will save me the initial phase
> of the subscription of copying the database) (Push subscription)
> Is that possible and how?
> Thank you,
> Samuel
>
>
|||Samuel,
provided you have an up-to-date copy of the database on the subscriber, you
could do a nosync initialization:
http://www.replicationanswers.com/No...alizations.asp
http://www.replicationanswers.com/NoSyncOn2005.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .