all groups > sql server (alternate) > december 2004 >
You're in the

sql server (alternate)

group:

transactional replication - re-syncing publisher from subscriber after failure


transactional replication - re-syncing publisher from subscriber after failure tgru
12/29/2004 5:30:24 PM
sql server (alternate): I have taken over a transactional replication setup that is being used
for fault tolerance (I know, I know...).

The scenario I am concerned with is where the publisher goes down due to
failure, so we need to point our application at the subscriber and start
updating the data there. We are not using the immediate updating option.

How do I go about re-syncing the publisher with the data that been added
to, or changed on the subscriber, when the publisher comes back online?

Thanks,

TGru

*** Sent via Developersdex http://www.developersdex.com ***
Re: transactional replication - re-syncing publisher from subscriber after failure GM
12/30/2004 7:25:14 AM
you might want to use Merge Replication instead of Transactional
Replication.
AddThis Social Bookmark Button