Walkthrough Setting up SQL 2008 Peer-2-Peer Replication
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.