PrepAway - Latest Free Exam Questions & Answers

Tag: peer-to-peer replication in sql server subscriber

Which value should you configure for the @sync_type parameter of the sp_addsubscription system storedprocedure

You are the database administrator of your company. You have two SQL Server 2008 servers in a peer-to-peertransactional replication topology. You are in the process of adding a new node to the peer-to-peer transactionalreplication. You want to ensure that all relevant transactions are replicated to the new node.
Which value should you configure for the @sync_type parameter of the sp_addsubscription system storedprocedure?