1

I have a database architecture with: => 1 distributor running on a dedicated instance of SQL Server 2005 => 2 publishers running each on a dedicated instance of SQL Server 2000 and SQL Server 2005 => A dozen subscriber running SQL Server Express / Sql Server 2000

I need to move the distributor instance to an other server with an other IP address, and I would like to have to re-publish-synchronise the whole architecture. How can I can Backup / Restore the distributor on a new server and have the publishers and subscribers connect to its new ip address?

1 Answer 1

1

Replication is tied to the machine name of the distributor. If the new instance will have the same machine name then stop the agents, backup the distributor, and restore it using the keep_replication setting as on. Then restart the agents.

If the hostname of the distributor is changing you'll want to tare down the replication and rebuild it.

2
  • I was wondering, if by updating specific system tables, it was possible to change also the machine name?
    – Olivier S
    Oct 18, 2011 at 5:43
  • It's possible I'm sure. I don't know the tables which you'd need to update, some major digging into the replication tables would be needed. There are tables at the publisher and subscriber that would need to be checked as well.
    – mrdenny
    Oct 18, 2011 at 22:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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