Sudharshan Prahallada, Microsoft SQL Replication Support team walks through setting up Peer-2-Peer Transactional Replication on SQL 2008. You can view this video from the BLOG or double-click to open in YouTube. He did a great job showing the Peer-2-Peer Wizard and explaining how it all comes together in a 5 minute video. For demonstration purposes he used SQL Agent account as the security account for the LogReader Agents and Distributor Agents. For production systems, we recommend creating dedicated Windows domain accounts for these Agents.
We’ll soon have additional videos walking through Transactional Replication and Web Synchronization.
Let us know what other topics you would like to see in these short on-demand training videos.