Post reply

Merge Replication -- replacing a subscriber

  • March 4, 2015 at 12:51 pm

    #295692

    Hello,

    I have a set up that I need to research, and I need direction...

    We have a central office with a SQL2005SP4 server (yeah, I know... old as heck) that's the main database and it has multiple subscribers in regional offices.

    Well... one of the regional offices server is failing, and it needs to be replace.

    The original server is an ancient Win2003 86x

    The Server team will build a new Win2008r2 64x, and use the same name and IP address

    and I'm tasked with the SQL part.

    I'll be installing the same version/patch of SQL, but 64x instead, and migrate all databases, including the system databases.

    How do I handle replication? Do I need to reintialize from scratch? or can I just use the backup as a starting point?

    Thank you so much

    Miguel

  • March 4, 2015 at 2:31 pm

    #1781779

    Yes you can restore and reinitialize but I'm not sure if you need to add a new server as a subscriber first.

    Alex S

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply