"S c o t t K r a m e r" <sckramer2000@hotmail.com> wrote in message
news:5f622$42de9454$a227293d$27937@ALLTEL.NET...
> Hello:
>
> I'd like to migrate an in production merge repl topology to a new server:
>
> here's my plan (in a lab first)
>
> 1. turn off the vpn (subs simply can't connect & sync)
> 2. install the new server (create matching the ip & servername) install
> sql & match sp levels (builds) of orig server
> -- so all connectivity & names will look the same to the subs
> 3. backup the current pub db & restore on new server
>
> 4. all the pieces????
>
> is there a way I can weed out the pieces from the dist, master, msdb db, &
> restore them on the new server??? is ther a sproc for this???
>
> Thanks!!
> Scott
>
>
> --
> Scott Kramer
> CDS Technologies, Inc.
> www.clevelanddata.com
> www.groundzerolan.com
> www.team501.com
>
>

"Hilary Cotter" wrote:

> There is no proc for this. You can restore the master, mdse, distribution
> and publication database, rename the new server with the name of the old
> server (take the old server offline before doing this), and then bounce the
> new publisher - this normally works.
>
> --
> 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
> "S c o t t K r a m e r" <sckramer2000@hotmail.com> wrote in message
> news:5f622$42de9454$a227293d$27937@ALLTEL.NET...
> > Hello:
> >
> > I'd like to migrate an in production merge repl topology to a new server:
> >
> > here's my plan (in a lab first)
> >
> > 1. turn off the vpn (subs simply can't connect & sync)
> > 2. install the new server (create matching the ip & servername) install
> > sql & match sp levels (builds) of orig server
> > -- so all connectivity & names will look the same to the subs
> > 3. backup the current pub db & restore on new server
> >
> > 4. all the pieces????
> >
> > is there a way I can weed out the pieces from the dist, master, msdb db, &
> > restore them on the new server??? is ther a sproc for this???
> >
> > Thanks!!
> > Scott
> >
> >
> > --
> > Scott Kramer
> > CDS Technologies, Inc.
> > www.clevelanddata.com
> > www.groundzerolan.com
> > www.team501.com
> >
> >
>
>