472,144 Members | 1,858 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,144 software developers and data experts.

transactional replication - re-syncing publisher from subscriber after failure

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?



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 23 '05 #1
1 1710
you might want to use Merge Replication instead of Transactional

Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Cherrish Vaidiyan | last post: by
9 posts views Thread by David W. Fenton | last post: by
24 posts views Thread by Ian Boyd | last post: by
3 posts views Thread by Gert van der Kooij | last post: by
reply views Thread by Saiars | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.