0

I'm using Transactional Replication and I've currently got three 2008r2 instances Publisher/Distributor/Subscriber.

I need to put three more 2008r2 instances on the same domain in the exact same configuration.

I'll be changing the Publisher Names, but I'd like to avoid changing the Publication Names.

I'm pretty sure this is safe to do, but in the past I've found replication to be "problematic".

Our set-up includes little quirks such as Indexed Views materialised as Tables and I also have concerns about Orphan meta-data lurking under the bonnet.

Has anybody had any problems with duplicate Publication Names and strongly advises against them? Any shared wisdom would be much appreciated.

enter image description here

1

Yes, it is fine to have same publication names on as many different publishers as you want. You most likely can't have dup publication names on a single publisher though, but that is not what you are asking. Further, you can easily test this out in your test/dev environment, on two servers. Create a single pub/dist/sub server, and on second server, create another pub/dist/sub, and on each, create a publication with same name.

About your comment "but in the past I've found replication to be "problematic" - please explain?

  • I've inherited a Legacy Repliction config that was originally set-up using custom scripts. But the scripts were not documented, consequently the "working" replication was left in place for 5 Years. But when changes had to be made the re-snapshot kept failing. It took days to figure out that the original builders had left Orphan meta-data in the sys tables from their original efforts to build Replication. Once the meta-data was cleaned-out then I was able to get the publisher back up and running. That was a hard lesson in Orphan Meta-data. Can you think of anything else I should worry about? – pacreely Feb 11 '17 at 11:19
  • Sounds like that should have its own thread. Otherwise, the question you ask should be answered above. – Greg Feb 11 '17 at 13:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.