Microsoft SQL Server forum - Rejoining replicating servers

Author

Rejoining replicating servers

Jim

2005-09-21, 7:23 am

We had a two-site system go badly wrong as a result of something. The net
result of this was that the publisher had to be completely reformatted and
reinstalled. The server has, as a result of this, been given a different
name (went from being a named instance to not being one).

Currently the publisher doesn't know it's a replicating system.

Is there any way to join these two together so that they just start
from where they left off, or will I have to re-do all the replication
from scratch by various SELECT INTOs to get the data across, then
pushing out fresh subscriptions?

Thanks,

Jim
--
Find me at http://www.ursaMinorBeta.co.uk
JediGeeks http://www.jedigeeks.com
"There's no 'I' in team, but there is a 'me' if you jumble
the letters up a bit." - Dr. House.

Simon Hayes

2005-09-21, 11:24 am

You might get a better response in
microsoft.public.sqlserver.replication.

Simon

Jim

2005-09-21, 11:24 am

In article <1127313805.460090.79830@g14g2000cwa.googlegroups.com>, Simon Hayes wrote:
> You might get a better response in
> microsoft.public.sqlserver.replication.
>

Thanks.

Jim
--
Find me at http://www.ursaMinorBeta.co.uk
JediGeeks http://www.jedigeeks.com
"There's no 'I' in team, but there is a 'me' if you jumble
the letters up a bit." - Dr. House.

Sponsored Links