Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question
add comment

1 Answer

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.

share|improve this answer
    
I was wondering, if by updating specific system tables, it was possible to change also the machine name? –  Olivier S Oct 18 '11 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 '11 at 22:25
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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