"Azhar Waheed" <AzharWaheed@discussions.microsoft.com> wrote in message
news:16A19885-3CB7-45D8-82AA-4662CAA42379@microsoft.com...
> We are running a three publication on our head office server (SQL Server
> 2000) with four subscriber at different location. We just bought a new
> server
> and want to replace the old server with new one.
>
> Is there is any way that I can move the publication from the old server to
> new server without dropping the subscriber. ?
>
> Azhar
>
>

"Hilary Cotter" wrote:

> You can stop all the agents, back up all the databases.
> Restore them all (even msdb, master, and distribution) on the new server,
> take the old server offline, rename the new server the name of the old
> server, reboot it and issue a sp_replrestart.
>
> --
> RelevantNoise.com - dedicated to mining blogs for business intelligence.
>
> 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
> "Azhar Waheed" <AzharWaheed@discussions.microsoft.com> wrote in message
> news:16A19885-3CB7-45D8-82AA-4662CAA42379@microsoft.com...
> > We are running a three publication on our head office server (SQL Server
> > 2000) with four subscriber at different location. We just bought a new
> > server
> > and want to replace the old server with new one.
> >
> > Is there is any way that I can move the publication from the old server to
> > new server without dropping the subscriber. ?
> >
> > Azhar
> >
> >
>
>