Tag: sp_addpublication

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

Chris Skorlinski [MSFT] Troubleshooting April 4, 2012

I recently encountered this error when setting up Transactional Replication via SQL scripts. [crayon-651711c96ba7c517210918/] 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

ReplTalk Try This December 5, 2010

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 »