Moving Published db to different server (cannot reinitialize)

Paul, Hilary , anyone.
Do you guys have a step by step instructions on
how to move a db to another publisher without
reinitializing? Isn't there like a "no sync"
option. I have seen you guys talk about
sometjhign of that sort in here. These tables we
replicate are too big to have to create new
snapshots and send them over. I want to avoid
the whole process and just pick up where it left
off after the db is moved. Can this be done just
using enterprise manager and not query analyzer?
Thanks,
comb
Do a final sync and stop the agents. Then do your move and do no sync
subscriptions.
This should work.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"Combfilter" <adsf@.asdf.com> wrote in message
news:MPG.1c20e370aa015dab989701@.news.newsreader.co m...
> Paul, Hilary , anyone.
> Do you guys have a step by step instructions on
> how to move a db to another publisher without
> reinitializing? Isn't there like a "no sync"
> option. I have seen you guys talk about
> sometjhign of that sort in here. These tables we
> replicate are too big to have to create new
> snapshots and send them over. I want to avoid
> the whole process and just pick up where it left
> off after the db is moved. Can this be done just
> using enterprise manager and not query analyzer?
> Thanks,
> comb
|||In article <erYjhRU3EHA.2788
@.TK2MSFTNGP15.phx.gbl>, hilary.cotter@.gmail.com
says...
> Do a final sync and stop the agents. Then do your move and do no sync
> subscriptions.
> This should work.
>
thanks. Can i do no sync option from Enterprise
Manager. I don't recall seeing that
Thanks
-comb