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.
asked Jun 08, 2010 at 01:27 PM in Default