TechNet
Export (0) Print
Expand All

Enable Initialization with a Backup for Transactional Publications (SQL Server Management Studio)

 

Applies To: SQL Server 2016

To initialize a subscription to a transactional publication from a backup, enable the publication to allow initialization from a backup, and then specify backup information when creating the subscription:

To enable initialization with a backup

  1. On the Subscription Options page of the Publication Properties - <Publication> dialog box, select a value of True for the Allow initialization from backup files option.

Initialize a Transactional Subscription Without a Snapshot

Community Additions

ADD
Show:
© 2016 Microsoft