Friday, March 9, 2012

Replication - Publisher moving to a different server

My disclaimer: Ive never done this. These are just
theories.
I would have to imagine that as long as the new box has
the same name as the old, and the data files go to the
same location on the destination as they were on the
source, you should be good. You should be able just to
backup/ restore master/ msdb and the user db's should be
alive and in-tact. No matter what advice you get here, do
this in a test environment and get backups before you do
anything.

>--Original Message--
>Hi,
>I need to move my publisher to a different database as
the current server on
>which it is running is slow compared to my current
requirements.
>But I have 2 subscribers to this server. I have merge
replication in SQL
>Server 2k with sp3 on.
>Can someone advice me as to how to have a smooth
transition? I cannot just
>replace the harddisk as the new server has a much
powerful harddisk.
>Is it possible for me to just restore the backup of the
current publisher on
>the new server alongwith the master and msdb, and
replication starts? I will
>take care to name the new server as the old one and
remove the old one from
>the network.
>Can someone please help me with the same?
>Thank you in advance.
>Regards,
>Karthik
>
>.
>
Hi Chris,
Thank you for the advice. I will test it on on a different machine and let
you know as to how things went.
Thank you once again.
Regards,
Karthik
"ChrisR" wrote:

> My disclaimer: Ive never done this. These are just
> theories.
> I would have to imagine that as long as the new box has
> the same name as the old, and the data files go to the
> same location on the destination as they were on the
> source, you should be good. You should be able just to
> backup/ restore master/ msdb and the user db's should be
> alive and in-tact. No matter what advice you get here, do
> this in a test environment and get backups before you do
> anything.
>
>
> the current server on
> requirements.
> replication in SQL
> transition? I cannot just
> powerful harddisk.
> current publisher on
> replication starts? I will
> remove the old one from
>

No comments:

Post a Comment