Tag: sp_addpublication

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. [crayon-5cbd81485c433940079385/] Looking at my create Publication script I see the default @sync_method = N’concurrent’ being set in sp_addpublication.  Nothing I want to change here. Further in my script I see the call to sp_addsubscription.  From the BOL, this syntax look correct.  I’m
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 »