SQL Server Performance Forum – Threads Archive
Standby distributor
Hi, I’m trying to implement transaction based replication. What would be the beststrategy 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 articlehttp://www.sqlmag.com/Articles/Index.cfm?ArticleID=39647 where most of the topic is covered to handle. HTH _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
]]>