Saturday, September 02, 2006
Peer-to-Peer Replication in SQL Server 2005
Even long time DBAs have to work hard at learning all the ins and outs of the new replication paradigms in SQL Server 2005. One new model is "Peer to Peer Replication" which is really based on transactional.
This article - http://www.microsoft.com/technet/technetmag/issues/2006/07/InsideMSFT/default.aspx - talks about how Peer-to-Peer replication with SQL Server 2005 is used internally at Microsoft to implement a type of SQL Server load balancing. An interesting read...
Another good article is here: The Growing Importance of Peer to Peer Replication.
This article - http://www.microsoft.com/technet/technetmag/issues/2006/07/InsideMSFT/default.aspx - talks about how Peer-to-Peer replication with SQL Server 2005 is used internally at Microsoft to implement a type of SQL Server load balancing. An interesting read...
Another good article is here: The Growing Importance of Peer to Peer Replication.
Technorati Tags: Load Balancing, replication, SQL Server, SQL Server 2005, SQL Server, Microsoft SQL Server
