SQL Server 2000 Server Rename and Replication

I am swapping out SQLServer2000 hardware for storage upgrades, using log shipping and server rename instance rename and ip change to old address. We have done this in the past for hardware upgrades and it works fine, however this server has a transactional with snapshot replication publisher database on it. Will I have to remove the publication and restart new from the new hardware? or will it be okay because it will be logshipped and the replicated tables are already there.


more ▼

asked Jun 08, 2010 at 01:27 PM in Default

avatar image

Laura 1
1 1 1 1

Not sure if I am the only one confused by the info in the question, can you break it down a bit more please? Make up names for servers and explain where replication takes place and what is being changed... we may be able to offer some advice.

Jun 09, 2010 at 05:12 AM Fatherjack ♦♦
(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jun 08, 2010 at 01:27 PM

Seen: 1285 times

Last Updated: Jun 08, 2010 at 01:27 PM

Copyright 2018 Redgate Software. Privacy Policy