@alt_snapshot_folder for PULL Subscribers

–Chris Skorlinski, SQL Server Escalation Services To improve SQL Distribution agent performance when applying Snapshot, first ZIP then copy the snapshot files locally to the subscriber. This is a great solution for subscribers on WAN international networks as ZIP can be smaller and faster to copy then Replication can move uncompressed Snapshot files.  Testing shows…


Specify all articles when subscribing to a publication using concurrent snapshot processing.

Specify all articles when subscribing to a publication using concurrent snapshot processing. Chris Skorlinski Microsoft SQL Server Escalation Services I recently encountered this error when setting up Transactional Replication via SQL scripts. Msg 14100, Level 16, State 1, Procedure sp_MSrepl_addsubscription, Line 533 Specify all articles when subscribing to a publication using concurrent snapshot processing. Looking…

1

How to: Initialize a Transactional Subscription from a Backup with Multiple Backup Files

How to: Initialize a Transactional Subscription from a Backup with Multiple Backup Files Chris Skorlinski Microsoft SQL Server Escalation Services Below is a slight modification to the How to: Initialize a Transactional Subscription from a Backup steps to handle Publisher database backups to multiple BAK FILES. 1)       Execute sp_addpublication (Transact-SQL) at the Publisher on the…

2