By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,414 Members | 1,586 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,414 IT Pros & Developers. It's quick & easy.

transactional replication - re-syncing publisher from subscriber after failure

P: n/a
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 ***
Don't just participate in USENET...get rewarded for it!
Jul 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
GM
you might want to use Merge Replication instead of Transactional
Replication.

Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.