Tag Archives: transactional replication in sql server 2005

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.. Continue reading →