Tag: initialize with backup

ReplTip – Subscribe to “all” restriction using “Initialize with backup”

ReplTip – Subscribe to “all” restriction using “Initialize with backup” Chris Skorlinski Microsoft SQL Server Escalation Services I ran into a couple of challenges using the Backup\Restore method to setup a SQL Server Replication Subscriber.  In particular, using this method you are unable to subscribe or un-subscribe to an individual article.  Using Backup\Restore you mush
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 »