Replication Whitepaper

Question

Hello,

i´m looking for a "deep space" documentation about the servers SQL replication.
I would like to study the internal expiries under the replication SQL.
What doing the SQL Server behind the scene?
Any idea where I get this?


Thanks

Answer 1

Hello,

besides the SQL Server online help there aren't many additional sources
dedicated to replication.

Have a look at:
Hilary Cotter: A Guide to SQL Server 2000 Transactional and Snapshot Replication

and Paul Ibson's Replication Answers

HTH Elmar

Answer 2

Hello JediMeister,

See also these additional resources:

Peer-to-Peer Transactional Replication

Best Practices for Replication Administration

http://blogs.msdn.com/sqlcat/archive/2007/05/07/sql-server-2005-transactional-replication-benefit-of-using-subscriptionstreams-for-low-bandwidth-high-latency-environments.aspx

Merge Replication Performance Improvements in SQL Server 2005

Best regards,

Robert