Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

REPLICATION Expand / Collapse
Posted Thursday, July 11, 2013 12:49 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, October 19, 2015 11:38 AM
Points: 49, Visits: 237
I set up a Transactional Replication with three servers one for Publisher, one for Distributor and the third one for the Subscriber, and everything was working perfectly but of recent we had issues with the Server that host the Distributor and we could not access the server. So I created a new SQL Instance to replace the old distributor but the Publisher is recognizing the old distributor. Please can I do to make the Publisher recognize the new Distributor.
Post #1472736
Posted Friday, July 12, 2013 11:58 AM



Group: Administrators
Last Login: Today @ 1:04 PM
Points: 34,375, Visits: 18,596
I believe you need to drop and reconfigure replication with a new distributor. You should have scripted out replication as soon as it's set up since problems can result in the need to rebuild it.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1473188
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse