x

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.

Thanks

more ▼

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

Laura 1 gravatar 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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x473
x305

asked: Jun 08, 2010 at 01:27 PM

Seen: 954 times

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