Home Forums SQL Server 2014 Administration - SQL Server 2014 Moving distribution database from one server to another with minimal downtime and without breaking replication RE: Moving distribution database from one server to another with minimal downtime and without breaking replication

  • Sue_H - Thursday, February 8, 2018 2:15 PM

    ffarouqi - Thursday, February 8, 2018 12:38 PM

    I would like to know if there is a possibility or a hack that can be used to move the distribution database from one server to another without breaking/dropping replication. I've read through many blog posts and they all show a methodology to break replication and recreate it. I would like to do a quick switch so need help in getting it to as minimum as possible.

    There are several articles on how to do that without recreating or reinitializing. One of the issues is that it can be a bit different for the different setups. You need to test them in your non-production environment. Here is one that seems to address most things:
    SQL Server Transactional Replication Moving Distribution Database – step-by-step guide

    Sue

    I am not sure if you understood my question. Article referenced is actually generating scripts to drop and recreate.