Setting Up SQL Server 2005 Transactional Replication Without A Snapshot

SQL2005 Publication Wizard Snapshot Agent

By default, SQL Server 2005 Replication requires that an initial snapshot of the publishing database be created before a subscription is synchronized. For large databases, snapshot creation could take long hours and render the database unusable for quite a while. Is there a way to configure transactional replication without having an initial snapshot? Well, after googling and reading the many resources online, there indeed is a way. Interested? Read on..

155 queries in 1.124 seconds.