Standby distributor | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Standby distributor

Hi, I’m trying to implement transaction based replication. What would be the best
strategy to protect the distributor from the outages? Thanks. Siva

One of the advantage of transactional replication is that the distributor holds the transactions until the subscriber prcoess in push mode. In pull mode, I guess the distributor holds the transactions for a specified length of time before deleting them. One of the article referred :
I would go with a "two-phase commit" approach to disaster recovery is that it will significantly reduce performance, and not accomplish what you want. If your applications are going to require that a transaction only be committed if two servers
are up and running.
In general for the DR recently refer to Kalen’s article where most of the topic is covered to handle. HTH _________
Satya SKJ