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

  • Have you considered log shipping by restoring the DB to the new server with NORECOVERY and then shipping the logs there? I imagine you then have to agree on a cutoff period then you stop all transactions then backup and restore the last tlog and online the DB.

    You can read-only the old db so you can be assured no new transaction goes in.