July 23, 2007 at 11:58 pm
Hi
I am relatively new to replication as I inherited a set up where we replicate nearly all of a 1.3 gB db from Sydney OZ, to the UK. Most of the publications are merge some are transactional.
Question is if here in Sydney users realise - after half a day's work - they need to roll back to the previous day, for example, so I go to last night's backup, what happens to the replication process?
I am imagining a big mess!
I have others as well...
thanks for any answers
Paul
July 24, 2007 at 1:45 am
...just thought of a way, drop all replication subscriptions and publications, restore the Sydney db, then restore the UK one as as it would have been as at or before the Sydney backup. Restore the replication from scripts (have all that ready to go), and reestablish.
There's got to be more to it than that!
Paul
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply