Tag: Transactional

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

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 at my create Publication script I see the default @sync_method = N’concurrent’ being set in sp_addpublication.  Nothing I want
Read More »

Replicating data loaded with BCP or Bulk Insert

Yes you can use both Transactional and Merge Replication to move data inserted using the BCP.exe utility of the Bulk Insert command to Subscribers. Considerations For Transactional Replication By default, Transactional Replication will replicate data loaded via BCP or Bulk Insert.  For performance, you may want to load data using the bcp Utility –b batch_size
Read More »

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

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 publication database. Specify a value of true for @allow_initialize_from_backup = N’true’ and @immediate_sync = N’true’ 2)       Create a backup of
Read More »