all groups > sql server replication > june 2004 >
You're in the

sql server replication

group:

Would this work for moving a server doing replication?


Would this work for moving a server doing replication? Combfilter
6/29/2004 4:39:58 PM
sql server replication:


http://vyaskn.tripod.com/moving_sql_server.h
tm

I can see how it would work for just a sql
server, but a sql server doing replication
it might be harder to accomplish. Has
anyone here done this with a replication
box?

TIA,

Re: Would this work for moving a server doing replication? Hilary Cotter
6/30/2004 7:12:56 AM
The name of the publisher is hardcoded in the replication metadata tables. I
don't think this will work.

[quoted text, click to view]

Re: Would this work for moving a server doing replication? Paul Ibison
6/30/2004 8:54:07 AM
If the servername is identical and you use KEEP_REPLICTION then it is
possible to retain the publication replication settings. If not, then I
script out the publications, create the new server, edit the scripts -
changing server names and logins for job owners if necessary - and then
recreate the publications. This is followed by initialization of course.
HTH,
Paul Ibison

AddThis Social Bookmark Button