New Peer Initialization (peer-to-peer replication)
Use the New Peer Initialization page to specify how peer databases were initialized (peers must be initialized before completing this wizard). Peers are initialized manually or by using the initialize with backup functionality provided by transactional replication (peer-to-peer transactional replication does not support initializing peers with a snapshot). If different peers were initialized using different methods, you must make two passes through this wizard.
Options
Specify how the new peer database(s) was initialized
The schema and data for all published objects must be present at each peer. Select one of the following options:- Select the first option if you have: created the schema for published objects manually; or you have restored a backup, and no data changes have been made at the first publication database since the backup was taken. If you created the schema manually, you must ensure that all required data is present at each peer. This option corresponds to a value of replication support only for the subscription property sync_type.
- Select the second option if you have restored a backup, and data changes have been made at the first publication database since the backup was taken. Replication must now deliver changes from the first publication database that were not included in the backup. This option corresponds to a value of initialize with backup for the subscription property sync_type.
When a publication is enabled for peer-to-peer replication, the allow_initialize_from_backup publication property is set. Replication immediately starts to track changes in the first publication database, so these changes can be delivered to a restored database at one or more peers if the initialize with backup option is selected. Click the Browse button to navigate to the backup used and replication will read the log sequence number (LSN) from the backup. All changes in the first publication database that have a higher LSN will be delivered to each peer.
See Also
Other Resources
How to: Configure Peer-to-Peer Transactional Replication (SQL Server Management Studio)
How to: Administer a Peer-to-Peer Topology (Replication Transact-SQL Programming)
Peer-to-Peer Transactional Replication
Replication Properties
Replication Wizards