ReplTalk
All about Microsoft SQL Replication

What happens if I select Create a snapshot immediately in the Publication Wizard?

Chris Skorlinski [MSFT] Inside Replication, Try This April 22, 2010

When creating a Transactional Replication publication, what happens if I check Create a snapshot immediately and keep the snapshot available to initialize subscriptions? This sets the publication property @property=‘immediate_sync’,@value=‘TRUE’ which instructs Replication to keep all the transactions cached in the Distribution database for the entire Retention Period.  Normally these rows are purged as soon as
Read More »

Executing batch UPDATE commands on Publisher and its affect on Transactional Replication

Chris Skorlinski [MSFT] Inside Replication, Try This March 15, 2010

José Moreira Neto | Microsoft SQL Server Escalation Services Problem 1: batch updates 1)      A single update command can generate a transaction with thousands of commands. For example if you execute an UPDATE statement that updates 10K rows on the publisher, up to 20K commands can be send over to the subscriber. On the publisher
Read More »

The Difference between alt_snapshot_folder and AltSnapshotFolder

Chris Skorlinski [MSFT] Inside Replication March 15, 2010

Sometimes MS SQL Replication developers use similar names for similar meaning but which can have very different results.  These settings both specify alternate location for the Snapshot files, however, one is set at the publication and one at an individual subscriber. alt_snapshot_folder The alt_snapshot_folder parameter is set at the Publisher for ALL subscribers.  This can
Read More »

website challenges

ReplTalk ReplTalk Blog December 6, 2023

Sorry, but Repltalk.com website is having a few challenges today and we’re working to get these corrected. There has been a critical error on this website. Chris Skorlinski